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: 163

Filed under:

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

Related posts about postgresql