From: | Dave Page <dpage(at)vale-housing(dot)co(dot)uk> |
---|---|
To: | "'Jason Kwok'" <jason(at)newhonest(dot)com>, pgadmin-support(at)postgresql(dot)org |
Subject: | Re: Error in connecting remote PgSQL server |
Date: | 2001-09-27 08:27:42 |
Message-ID: | AA30E7BCCA5C1D4E88A231900F8325C00B2B@dogbert.vale-housing.co.uk |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
> -----Original Message-----
> From: Jason Kwok [mailto:jason(at)newhonest(dot)com]
> Sent: 27 September 2001 07:12
> To: pgadmin-support(at)postgresql(dot)org
> Subject: [pgadmin-support] Error in connecting remote PgSQL server
>
>
> When trying to connect to a remote pgsql server, pgadmin log
> an error : Log : ========= 200/9/27/PM 02:06:57:- Error in pgAdmin II:
> fromConnect.cmdConnect_click: -2147217843 - No pg_hba.conf
> entry for host 192.168.1.2, user MYNAME, database template 1 =========
>
> 1. 192.168.1.2 is the windows box runnig pgAdmin
> 2. the ip of remote pgserver is 192.168.1.103
>
> Do I need to create anything like pg_hba.conf in my window box?
Hi,
No, you don't need to do anything on the Windows box, however on the server,
you need to edit $PGDATA/pg_hba.conf and add an entry to allow your PC
access to the template1 database:
E.g.
host all 192.168.1.2 255.255.255.255 password
This line would grant your workstation access to all databases with password
authentication.
Regards, Dave.
From | Date | Subject | |
---|---|---|---|
Next Message | Thomas Sandford | 2001-09-27 17:54:41 | Failed to load control "HBX" |
Previous Message | Jason Kwok | 2001-09-27 06:12:11 | Error in connecting remote PgSQL server |