Postgres Pro
Downloads
Home   >   mailing lists

Thread: Connecting to PostgreSQL on Linux with windows

Connecting to PostgreSQL on Linux with windows

From
"mmaclennan"
Date:
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?

Re: Connecting to PostgreSQL on Linux with windows

From
"chris smith"
Date:
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/

Re: Connecting to PostgreSQL on Linux with windows

From
Tom Lane
Date:
"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