User Tools

Site Tools


postgresql

Differences

This shows you the differences between two versions of the page.

Link to this comparison view

Both sides previous revisionPrevious revision
Next revision
Previous revision
postgresql [2023/02/03 11:13] keremetpostgresql [2025/03/22 21:32] (current) keremet
Line 40: Line 40:
   postgres    4452    4444  0 17:22 ?        00:00:00 postgres: logical replication launcher    postgres    4452    4444  0 17:22 ?        00:00:00 postgres: logical replication launcher 
      
 +
 +**Сервер на базе Simply Linux**
 +
 +  sudo apt-get update
 +  sudo apt-get install postgresql15-1C postgresql15-1C-server
 +  sudo /etc/init.d/postgresql initdb
 +
 +БД в каталоге /var/lib/pgsql/data
 +
 +  sudo systemctl enable --now postgresql
 +
 +  psql postgres -U postgres
 +
 +
 +  sudo apt-get remove libX11
 +  sudo apt-get remove lightdm
 +  sudo apt-get remove samba
 +  sudo apt-get remove ModemManager
 +  sudo apt-get remove avahi-daemon
 +  sudo apt-get remove polkit
 +  sudo apt-get remove NetworkManager-daemon
 +  sudo apt-get remove rpcbind
 +  sudo apt-get remove upower
 +
 +  [keremet@host-15 ~]$ cat /etc/net/ifaces/ens3/options
 +  BOOTPROTO=dhcp
 +  TYPE=eth
 +  DISABLED=no
 +  CONFIG_WIRELESS=no
 +  SYSTEMD_BOOTPROTO=dhcp4
 +  CONFIG_IPV4=yes
 +  SYSTEMD_CONTROLLED=no
 +  [keremet@host-15 ~]$ 
 +
 +https://www.altlinux.org/PostgreSQL
  
 Курсы https://postgrespro.ru/education/courses Курсы https://postgrespro.ru/education/courses
  
 +[[подключение_из_postgresql_к_greenplum|Подключение из PostgreSQL к Greenplum]]
postgresql.1675422790.txt.gz · Last modified: 2023/02/03 11:13 by keremet