Thread: 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?

==
====
Best Regards
Jason Kwok
==============
====


---
Virus Free
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.281 / Virus Database: 149 - Release Date: 2001/9/18

> -----Original Message-----
> From: Jason Kwok [mailto:jason@newhonest.com]
> Sent: 27 September 2001 07:12
> To: pgadmin-support@postgresql.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.