Re: [GENERAL] Problem Connecting to 5432

2006-06-14 Thread Casey, J Bart
, J Bart; pgsql-general@postgresql.org Subject: Re: [GENERAL] Problem Connecting to 5432 My mistake, the "-h host_IP" explicitly states which IP address to listen on. /usr/bin/postmaster -h your_IP -p 5432 -D /var/lib/pgsql/data -i I'm not sure if postgresql v7.x.y already

Re: [GENERAL] Problem Connecting to 5432

2006-06-14 Thread Tom Lane
"Casey, J Bart" <[EMAIL PROTECTED]> writes: > 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. You need to restart (not just SIGHUP) the postmaster to get

Re: [GENERAL] Problem Connecting to 5432

2006-06-13 Thread louis gonzales
My mistake, the "-h host_IP" explicitly states which IP address to listen on. /usr/bin/postmaster -h your_IP -p 5432 -D /var/lib/pgsql/data –i I'm not sure if postgresql v7.x.y already used the pg_ctl command which is essentially a wrapper for postmaster, if so use, pg_ctl -w -o "-h your_IP

Re: [GENERAL] Problem Connecting to 5432

2006-06-13 Thread louis gonzales
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 l

[GENERAL] Problem Connecting to 5432

2006-06-13 Thread Casey, J Bart
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