newbie with postgresql

[zum]

Hi,
I've just installed postgresql7 on my FreeBsd 4.8 server. Everything is running and I've created a small database to test on. The problem is I'm trying to install and windows based program called DBManager and when I try to connect to the server I get the following error message:

server message: could not connect to server: connection
refused (0x0000274D/10061) is the server running on host
172.x.x.x and accepting TCP/IP connections on port 5432?

Any ideas how to fix this.

Thanks,

zum

 

[azimuth0]

You need to let remote users access postgres, preferably with a username/password, and even more preferably through SSL.

In your data directory, look for these parameters and set them:

tcpip_socket = true
ssl = true

...

port = 5432

http://www.sanctuary.org/~azimuth/

 

[azimuth0]

Oh, yeah. Also in your data directory there's a file called pg_hba.conf that contains access privileges. You need to add your windows box to it - the comments in the file itself explains how.

http://www.sanctuary.org/~azimuth/

 

[zum]

well I've changed my postgresql.conf file to what you suggested and the pg_hba.conf file and still no luck. Here is what I have in the pg_hba.conf file.

host all 172.x.x.x 255.255.255.255 trust

Any thing else?

Thanks

Zum

 

[Leland123]

Hi zum,

Have you tried starting postgres? You can refer to the document about how to start the postgresql service. Maybe this will help.

http://www.smvfp.com/pgsqlhtml/postmaster-start.html

LelandJ

Leland F. Jackson, CPA
Software - Master (TM)

http://www.smvfp.com

Nothing Runs Like the Fox

 

[azimuth0]

Your line should read:
host all all 172.0.0.0 255.0.0.0 trust

You should also start/restart postgres after making this change.

-

http://www.sanctuary.org/~azimuth/

 

[zum]

thank for you help.. Problem solved.