Re: [GENERAL] Remote connection shows localhost databases

2011-09-16 Thread Jeff Adams
Thanks Guillaume and Richard. I removed the server from the host name field and entered only the IP address. I then edited my pg_hba.conf, adding the IP address and it worked! I appreciate all of your help. Jeff > > Thanks for the response Richard. I have tried to connect via pgAdminIII. > Wh

Re: [GENERAL] Remote connection shows localhost databases

2011-09-16 Thread Richard Huxton
On 15/09/11 22:40, Guillaume Lelarge wrote: On Thu, 2011-09-15 at 15:30 -0400, Jeff Adams wrote: When I try to connect to the remote machine, I enter \\\ into the host name field. The host field should contain the socket complete path, or the host name, or the ip address. As Guillaume says

Re: [GENERAL] Remote connection shows localhost databases

2011-09-16 Thread Richard Huxton
On 16/09/11 09:01, Guillaume Lelarge wrote: On Fri, 2011-09-16 at 08:14 +0100, Richard Huxton wrote: Odd that pgAdmin doesn't give an error though. Probably because the OP entered the Windows networking path in the Name field, and didn't change the Host field. In which case, pgAdmin most like

Re: [GENERAL] Remote connection shows localhost databases

2011-09-16 Thread Guillaume Lelarge
On Fri, 2011-09-16 at 08:14 +0100, Richard Huxton wrote: > On 15/09/11 22:40, Guillaume Lelarge wrote: > > On Thu, 2011-09-15 at 15:30 -0400, Jeff Adams wrote: > >> > >> When I try to connect to the remote machine, I enter > >> \\\ > >> into the host name field. > > > >The host field should contai

Re: [GENERAL] Remote connection shows localhost databases

2011-09-15 Thread Guillaume Lelarge
On Thu, 2011-09-15 at 15:30 -0400, Jeff Adams wrote: > [sorry for the duplicate Richard] > > Thanks for the response Richard. I have tried to connect via pgAdminIII. > When I try to connect to the remote machine, I enter \\\ > into the host name field. What I found was it didn't matter what I ente

Re: [GENERAL] Remote connection shows localhost databases

2011-09-15 Thread Jeff Adams
376 email: jeff.ad...@noaa.gov -Original Message- From: Richard Huxton [mailto:d...@archonet.com] Sent: Thursday, September 15, 2011 2:50 PM To: Jeff Adams Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] Remote connection shows localhost databases On 15/09/11 17:30, Jeff Adams w

Re: [GENERAL] Remote connection shows localhost databases

2011-09-15 Thread Richard Huxton
On 15/09/11 17:30, Jeff Adams wrote: I am trying to connect to a workstation running postgres from another computer on the network. How are you connecting? PgAdmin, psql, Perl script? What is the hostname you are using on the local machine and are you sure it is for the remote machine? --

[GENERAL] Remote connection shows localhost databases

2011-09-15 Thread Jeff Adams
I am trying to connect to a workstation running postgres from another computer on the network. I have postgres installed on both machines. When I go to connect to the workstation, everything appears to happen correctly, however, the server connection shows the databases on the localhost, not the wo