Обсуждение: PGAdmin connection failure

Поиск
Список
Период
Сортировка

PGAdmin connection failure

От
Rob Caulfield
Дата:
Hi hope you can help,
    I'm running Postgres on an OSX machine, all hunky dory and fine. The
problem comes when I try to connect to the databases through PGAdminII
(on a Win2K machine) I get the following error:-

Unable to connect to Ident server on the host which is trying to connect
to Postgres (IP address xxx.xxx.xxx.xxx, Port 113). errno = Connection
refused (61)


I've authorised the subnet that the connecting host is on to access the
Postgres server and set up the following user mappings:-



Map          User         Ident

postgres    postgres    postgres
admin        admin        admin


I've also created the user 'admin'  in the database I'm trying to
connect to, still no joy. The ODBC component has been configured. I
tried using an SSH tunnel with local forwarding to connect and got
exactly the same error.

Any light you could cast on this would be much appreciated.

Cheers,

Rob Caulfield.


Re: PGAdmin connection failure

От
Dave Page
Дата:

> -----Original Message-----
> From: Rob Caulfield [mailto:rob.caulfield@framestore-cfc.com]
> Sent: 12 February 2002 19:45
> To: pgadmin-support@postgresql.org
> Subject: [pgadmin-support] PGAdmin connection failure
>
>
> Hi hope you can help,
>     I'm running Postgres on an OSX machine, all hunky dory
> and fine. The problem comes when I try to connect to the
> databases through PGAdminII (on a Win2K machine) I get the
> following error:-
>
> Unable to connect to Ident server on the host which is trying
> to connect to Postgres (IP address xxx.xxx.xxx.xxx, Port
> 113). errno = Connection refused (61)

Hi Rob,

I don't know of any who is using pgAdmin II with ident, so to be honest, I
don't know if it will work or not. The error you're getting at the moment
sounds like you do not have an ident server running on your Win2K machine.
This is not a standard feature of Windows so you would need to get one from
somewhere else.

Another option would be to use password authentication which certainly
should work.

Regards, Dave.