sysdba.org

/usr/pgsql-10/bin/postgresql-10-setup initdb systemctl enable postgresql-10 systemctl start postgresql-10

1 2 3

/usr/pgsql-10/bin/postgresql-10-setup initdb systemctl enable postgresql-10 systemctl start postgresql-10

Kurulum tamamlandı şimdi bağlanabiliriz.

PostgreSQl in default portu  5432 dir. Çalışıp çalışmadığını kontrol edelim.

[root@yesrib ~]# netstat -ntlp |grep 5432 tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      17795/postmaster tcp6       0      0 :::5432                 :::*                    LISTEN      17795/postmaster sudo su - postgres -bash-4.2$ psql psql (10.3) Type "help" for help.

1 2 3 4 5 6 7

[root@yesrib ~]# netstat -ntlp |grep 5432 tcp        0      0 0.0.0.0:5432            0.0.0.0:*               LISTEN      17795/postmaster tcp6       0      0 :::5432                 :::*                    LISTEN      17795/postmaster sudo su - postgres -bash-4.2$ psql psql (10.3) Type "help" for help.

PgSQL

postgres=# select version(); --------------------------------------------------------------------------------------------------------- PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit (1 row)

1 2 3 4

postgres=# select version(); --------------------------------------------------------------------------------------------------------- PostgreSQL 10.3 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 4.8.5 20150623 (Red Hat 4.8.5-16), 64-bit (1 row)

Kaynak Koddan Kurulum

yum install -y readline-devel libtermcap-devel zlib zlib-devel tar xvfz postgresql-9.6.6 cd postgresql-9.6.6 ./configure mkdir /pg966 ./configure --prefix=/pg966 make    (make -h 8   ###for 8 core parallizm) make install cd contrib make make install mkdir /pg966/data chown postgres.postgres /pg966/data su - postgres initdb -D /data -E unicode

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21

yum install -y readline-devel libtermcap-devel zlib zlib-devel tar xvfz postgresql-9.6.6 cd postgresql-9.6.6 ./configure   mkdir /pg966   ./configure --prefix=/pg966   make    (make -h 8   ###for 8 core parallizm) make install   cd contrib make make install   mkdir /pg966/data chown postgres.postgres /pg966/data   su - postgres initdb -D /data -E unicode

Success. You can now start the database server using:

Kapat/Aç

pg_ctl -D /usr/local/pgsql966/data -l logfile start pg_ctl stop

1 2	pg_ctl -D /usr/local/pgsql966/data -l logfile start pg_ctl stop