Re: Unable to add server in PGadmin
От | manoj nair |
---|---|
Тема | Re: Unable to add server in PGadmin |
Дата | |
Msg-id | 559cda0d0712100529p3db1e09ah7ce4ac462c133a08@mail.gmail.com обсуждение исходный текст |
Ответ на | Re: Unable to add server in PGadmin (Dave Page <dpage@postgresql.org>) |
Ответы |
Re: Unable to add server in PGadmin
(Raymond O'Donnell <rod@iol.ie>)
|
Список | 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 по дате отправления: