Connecting to PostgreSQL on Linux with windows

On 10 May 2006 07:46:01 -0700, mmaclennan <mmaclennan@gmail.com> wrote:

Hi, I have a linux box (Fedora 3) running the latest version of
PostgreSQL and PostGIS. I am trying connect to the database through a
windows computer but can't seem to make the connection work. I've
configured the pb_hba.config file in the usr directory to as "host
all all 192.168.1.0/24 md5" but it doesn't seem
to work.

I know these are the correct settings because I installed PostgreSQL on
a windows based machine and can access that version no problem with the
aformentioned settings. Can a windows machine connect to a Linux
version of Postgresql if so what am I doing wrong?

What exactly "doesn't work" ? Do you get an error message? Does it time out? ...

--
Postgresql & php tutorials
http://www.designmagick.com/

"mmaclennan" <mmaclennan@gmail.com> writes:

Hi, I have a linux box (Fedora 3) running the latest version of
PostgreSQL and PostGIS. I am trying connect to the database through a
windows computer but can't seem to make the connection work. I've
configured the pb_hba.config file in the usr directory to as "host
all all 192.168.1.0/24 md5" but it doesn't seem
to work.

As already noted, providing no more detail than "doesn't seem to work"
is a good way to guarantee you won't get any useful responses. I'll
suggest two likely possibilities though:

* you forgot to start the postmaster with the option to make it listen
for TCP connections (tcpip_socket or listen_addresses depending on PG
vintage)

* you've got the kernel firewall configured in a way that doesn't let
through any packets to port 5432. (I believe this is default on most
RHEL/Fedora versions :-()

regards, tom lane