Try using the following format in the pg_hba.conf file:
host all all(or your_user_account) your_IP/32 trust (The 32 is the same
as 255.255.255.255 but in CIDR format)
As for the command line you started postmaster with, doesn't the "-i"
require an interface such as an IP address too? If you look below in
your comments, you specify "-i" after your DATA directory but never give
the "-i" an argument?
Casey, J Bart wrote:
All,
I have read message after message and searched the internet for hours,
yet I still can’t get a remote computer to connect to port 5432 on my
Fedora Core 3 system running Postgresql 7.4.7.
What I have done:
1) Stopped the iptables service
2) Modified postgresql.conf and added the following lines
tcpip_socket = true
port = 5432
3) Modified pg_hba.conf and added
host all all (my ip address) 255.255.255.255 trust
4) Modified the postgresql startup script to use the –i flag
5) Verified that postmaster is running with the –i flag… ps ax | grep
postmaster output:
4259 pts/1 S 0:00 /usr/bin/postmaster -p 5432 -D /var/lib/pgsql/data –i
6) Tried to verify that the server was listening on port 5432 only to
find out that it isn’t. The netstat output follows:
tcp 0 0 127.0.0.1:8438 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:5432 0.0.0.0:* LISTEN
tcp 0 0 127.0.0.1:25 0.0.0.0:* LISTEN
tcp 0 0 :::80 :::* LISTEN
tcp 0 0 :::22 :::* LISTEN
tcp 0 0 :::443 :::* LISTEN
As you can see it is only listening on the loopback interface
I’m quite certain the issue is how I am starting the service, but I’ve
added the –i flag.
I’m all out of ideas on this one. Any and all help is greatly appreciated.
Regards,
Bart
