Re: Server not listening

Hi George,

When you add a connection to PgAdmin you specify the port details and
the host name to connect to.
If the connection is already there, open it's properties to check the
settings. Did the telnet from your XP machine succeed, or fail? Do you
have any firewalls running on the server (e.g.
iptables/netfilter/shorewall (Linux systems) or IP filter (BSD systems))?

It's not a pg_hba.conf problem (yet) as that'd give you a different
failure message.

Andy.

George Heller wrote:
> 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)(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..
> >
> >
>
>
> ------------------------------------------------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check out new cars at Yahoo! Autos.
> <http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->
>
>
>
> ------------------------------------------------------------------------
> Ahhh...imagining that irresistible "new car" smell?
> Check out new cars at Yahoo! Autos.
> <http://us.rd.yahoo.com/evt=48245/*http://autos.yahoo.com/new_cars.html;_ylc=X3oDMTE1YW1jcXJ2BF9TAzk3MTA3MDc2BHNlYwNtYWlsdGFncwRzbGsDbmV3LWNhcnM->
> !DSPAM:37,462c630489291906970479!