Re: Unable to add server in PGadmin

Dave/rod,
I checked Under File -> Options -> Preferences, check the 'Reset guru
hints'
option, click OK, and then tried connecting again.

This time i got some hint regarding Primary Keys .. but nothing on the
connection specific errors..

The PGAdmin on the vista box is working all fine ..
i have added 2 servers to 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 ,,,

But its just not possible to add the postgres server on the Vista box ...
through the pgadmin client on my machine
:) .donno what i am missing again ..

Settings for the postgres server on vista which i cross checked are as
follows ...

Firewall settings checked ...everything fine ,,,Postgres server is not
blocked ...
postgresql.conf -------- listen_address = '*'
pg_hba.conf -----(host all all 0.0.0.0/0 trust) so that any system can
connect remotely....

Thanks,
manoj

On Dec 10, 2007 5:22 PM, Dave Page <dpage(at)postgresql(dot)org> wrote:

> Raymond O'Donnell wrote:
> > On 10/12/2007 11:41, manoj nair wrote:
> >
> >> The error message on the left most corner of PGAdmin
> >> says..."Connection to database ...Failed" and the
> >> add server form or dialog box pops up again.
> >> there is nothing much happening other than this.
> >
> > Yu should get a bit more than this....as an experiment, I stopped the
> > PostgreSQL service on my laptop (WinXP) and tried to connect with
> > pgAdmin - and a large window popped up quoting the error from libpq
> > ("could not connect to server: Connection refused (0x0000274D/10061) Is
> > the server running on host "127.0.0.1" and accepting TCP/IP connections
> > on port 5432?") and giving all sorts of useful advice.
> >
> > Do you not see something like this?
>
> Oh, I see how that can happen (the do not show this hint again' box has
> been checked).
>
> Under File -> Options -> Preferences, check the 'Reset guru hints'
> option, click OK, and then try connecting again.
>
> Regards, Dave.
>