Re: Server not listening

Well, I am not really able to verify that, as the PgAdmin doesn't connect in the first place. So the connections and authentication is disabled.

I think I know that the server is listening at the default port 5432, and I have switched off my windows firewall too, but I am not too sure what I can do next.

Any suggestions?

Thanks.
George

Melvin Davidson <mdavidson(at)cctus(dot)com> wrote:
Check that the value of Port in the pgadmin connection properties
matches the value of "port " in postgresql.conf on the server.

In should be located under the
# CONNECTIONS AND AUTHENTICATION

section of postgresql.conf

---------------------------------
From: pgadmin-support-owner(at)postgresql(dot)org [mailto:pgadmin-support-owner(at)postgresql(dot)org] On Behalf Of George Heller
Sent: Friday, April 20, 2007 1:27 PM
To: andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk
Cc: pgadmin-support(at)postgresql(dot)org
Subject: Re: [pgadmin-support] Server not listening

Hi,

Thanks for the reply. I did a telnet using the server's remote IP, and it worked! So I am assuming now that it is a firewall problem.... But I have turned off the windows firewall from my system, I have tried restarting the system too. No luck!

I have changed the pg_hba.conf to have the ip address of my windows machine. I have restarted the postgres server too. I am thinking that really isnt the problem, since my telnet, ping etc. all go through fine.

Anything else I can try? Really looking forward to getting around this problem!

Thanks!
George

Andy Shellam <andy(dot)shellam-lists(at)mailnetwork(dot)co(dot)uk> wrote:
Hi George,

From the server's console, do "telnet 5432."
Make sure to use the server's remote IP, not localhost. If that fails,
your PostgreSQL is not listening on that port correctly. If it
succeeds, then you've got a firewall problem.

If it's PostgreSQL isn't listening, make sure you have done a restart
(not just a reload) since making the chance in your configuration file
(just to make sure, if you can, stop then start it.) Also check you are
editing the correct file! (I.e. the one in the same cluster directory
that PostgreSQL is starting.)

Andy.

George Heller wrote:
> Hi,
>
> I tried a telnet, and it doesnt work. So atleast now I know there is
> something wrong with the server side, but I dont quite know what to do
> next..... Any suggestions?
>
> Is there some particular setup that needs to be done? I have disabled
> the Windows Firewall.
>
> Thanks.
> George
>
> */Andy Shellam /* wrote:
>
> Also from the machine you tried the ping from, do telnet
> 5432 - see if that connects.
> Something's definitely not quite correct on the server-side.
>
> Check any firewalls (particularly the Windows Firewall if running
> an XP
> SP2 or 2003 client machine.)
>
> Andy
>
> Raymond O'Donnell wrote:
> > On 18/04/2007 21:29, GeorgeHeller wrote:
> >
> >> I have changed the postgresql.conf file to have
> listen_addresses='*' and
> >> port=5432, and have restarted the server.
> >
> > if you have psql on another computer, try using it to connect to
> the
> > server and see what happens.
> >
> > psql -h (serveraddress) -U (username) -d (databasename) etc.
> >
> > Ray.
> >
> > ---------------------------------------------------------------
> > Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
> > rod(at)iol(dot)ie
> > ---------------------------------------------------------------
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an appropriate
> > subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
> > message can get through to the mailing list cleanly
> >
> >
> >
> >
>
>
> ------------------------------------------------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check out new cars at Yahoo! Autos.
>
> !DSPAM:37,4627d7de89291495521781!

---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check out new cars at Yahoo! Autos.

---------------------------------
Ahhh...imagining that irresistible "new car" smell?
Check outnew cars at Yahoo! Autos.