Postgres Remote Access
Posted
by
boot-baby-boot
on Server Fault
See other posts from Server Fault
or by boot-baby-boot
Published on 2011-11-30T16:28:15Z
Indexed on
2011/11/30
17:58 UTC
Read the original article
Hit count: 185
postgresql
I am trying to connect to postgres remotely.I have followed this tutorial http://www.cyberciti.biz/faq/howto-fedora-linux-install-postgresql-server/ and have executed the following commands to see if the remote access is possible.
[root@printmyworld ~]# egrep -i "(listen_addresses|port|tcpip_socket).*=.+" /var /lib/pgsql/data/postgresql.conf
#listen_addresses = '*' # what IP address(es) to listen on;
#port = 5432
[root@printmyworld ~]# lsof +c0 -anPiTCP -upostgres
COMMAND PID USER FD TYPE DEVICE SIZE NODE NAME
postmaster 9323 postgres 3u IPv4 2875987353 TCP 127.0.0.1:5432 (LISTEN )
postmaster 9323 postgres 4u IPv6 2875987354 TCP [::1]:5432 (LISTEN)
I am suspicious of this line:
postmaster 9323 postgres 3u IPv4 2875987353 TCP 127.0.0.1:5432 (LISTEN
My server ip address is 1yy.000.1xx.000 .Should it be 1yy.000.1xx.000:5432
© Server Fault or respective owner