Postgres Remote Access
- by boot-baby-boot
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