Thread: PGSQL Manager

PGSQL Manager

From
Rinku Shivnani
Date:
Dear all,
 
Wd you pls tell me how to configure PGSQL manager on Win98.
 
I have downloaded its trial version and installed it. But the system says Connection not succeed.
 
Wd you pls guide me on the same.
 
Regards,
Rinku


Do you Yahoo!?
Friends. Fun. Try the all-new Yahoo! Messenger

Re: PGSQL Manager

From
"Scott Marlowe"
Date:
On Sun, 2004-06-13 at 08:20, Rinku Shivnani wrote:
> Dear all,
>
> Wd you pls tell me how to configure PGSQL manager on Win98.
>
> I have downloaded its trial version and installed it. But the system
> says Connection not succeed.
>
> Wd you pls guide me on the same.

The likely problem is your database server, not win98.  You need to edit
two files and restart the system to gain remote access.

You need these lines in these files, located in $PGDATA on the database
server:

postgresql.conf:
tcpip_socket = true

pg_hba.conf:
host       all  all  10.0.0.1/255.255.255.0  md5

Then restart your pgsql instance and the changes should take effect.