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 <[EMAIL PROTECTED]>/* 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:* [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED] *On Behalf Of
*George Heller
*Sent:* Friday, April 20, 2007 1:27 PM
*To:* [EMAIL PROTECTED]
*Cc:* pgadmin-support@postgresql.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 <[EMAIL PROTECTED]>/* 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
> > [EMAIL PROTECTED]
> >
---------------------------------------------------------------
> >
> > ---------------------------(end of
> broadcast)---------------------------
> > TIP 1: if posting/reading through Usenet, please send an
appropriate
> > subscribe-nomail command to [EMAIL PROTECTED] 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!
---------------------------(end of broadcast)---------------------------
TIP 3: Have you checked our extensive FAQ?
http://www.postgresql.org/docs/faq
