Re: Problem Connecting to 5432

Louis,

Thank you very much for the info on the -h flag.  Somehow I missed that
in the postmaster man pages.  That did the trick!

Regards,

J. Bart Casey

-----Original Message-----
From: louis gonzales [mailto:gonzales@linuxlouis.net]
Sent: Wednesday, June 14, 2006 2:42 AM
To: louis gonzales
Cc: Casey, 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 used the pg_ctl command which
is essentially a wrapper for postmaster, if so use,

pg_ctl -w -o "-h your_IP -p your_PORT" -l logfile(if you wish) start

if you use "your_IP = 0.0.0.0" it will listen on all valid TCP/IP
interfaces, including 127.0.0.1(a.k.a. localhost)



louis gonzales wrote:

> 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
>>
>
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
>               http://archives.postgresql.org