Обсуждение: Connecting to PostgreSQL on Linux with windows
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?
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