Re: Unable to add server in PGadmin - Mailing list pgadmin-support

From manoj nair
Subject Re: Unable to add server in PGadmin
Date
Msg-id 559cda0d0712100529p3db1e09ah7ce4ac462c133a08@mail.gmail.com
Whole thread Raw
In response to Re: Unable to add server in PGadmin  (Dave Page <dpage@postgresql.org>)
Responses Re: Unable to add server in PGadmin
List pgadmin-support
Dave/rod,<br />       I checked Under File -> Options -> Preferences, check the 'Reset guru hints'<br />option,
clickOK, and then tried connecting again.<br /><br />This time i got some hint regarding Primary Keys .. but nothing on
theconnection specific errors.. <br /><br />The PGAdmin on the vista box is working all fine ..<br />i have added 2
serversto it one with the local host and the other with an ip address of a linux machine which has postgres running on
it....seems to be working perfectly ,,, <br /><br />But its just not possible to add the postgres server on the Vista
box... through the pgadmin client on my machine <br />:) .donno what i am missing again ..<br /><br />Settings for the
postgresserver on vista which i cross checked are as follows ... <br /><br />Firewall settings checked ...everything
fine,,,Postgres server is not blocked ... <br />postgresql.conf -------- listen_address = '*'<br />pg_hba.conf
-----(hostall all  <a href="http://0.0.0.0/0">0.0.0.0/0</a> trust) so that any system can connect remotely....<br /><br
/>Thanks,<br/>manoj <br /><br /> <br /><div class="gmail_quote">On Dec 10, 2007 5:22 PM, Dave Page <<a
href="mailto:dpage@postgresql.org">dpage@postgresql.org</a>>wrote: <br /><blockquote class="gmail_quote"
style="border-left:1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;"><div
class="Ih2E3d">RaymondO'Donnell wrote:<br />> On 10/12/2007 11:41, manoj nair wrote: <br />><br />>>      
 Theerror message on the left most corner of PGAdmin<br />>> says..."Connection to database ...Failed" and the<br
/>>>add server form or dialog box pops up again.<br />>> there is nothing much happening other than this.
<br/>><br />> Yu should get a bit more than this....as an experiment, I stopped the<br />> PostgreSQL service
onmy laptop (WinXP) and tried to connect with<br />> pgAdmin - and a large window popped up quoting the error from
libpq<br />> ("could not connect to server: Connection refused (0x0000274D/10061) Is<br />> the server running on
host"<a href="http://127.0.0.1" target="_blank">127.0.0.1</a>" and accepting TCP/IP connections <br />> on port
5432?")and giving all sorts of useful advice.<br />><br />> Do you not see something like this?<br /><br
/></div>Oh,I see how that can happen (the do not show this hint again' box has<br />been checked). <br /><br />Under
File-> Options -> Preferences, check the 'Reset guru hints'<br />option, click OK, and then try connecting
again.<br/><br />Regards, Dave.<br /></blockquote></div><br /> 

pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Fedora Core 8.0 status?
Next
From: Raymond O'Donnell
Date:
Subject: Re: Unable to add server in PGadmin