From: | Richard Huxton <dev(at)archonet(dot)com> |
---|---|
To: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
Cc: | Jeff Adams <Jeff(dot)Adams(at)noaa(dot)gov>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Remote connection shows localhost databases |
Date: | 2011-09-16 07:14:54 |
Message-ID: | 4E72F76E.7000505@archonet.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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 \\<server>\<ip_address>
>> 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 - try just the IP address to start with. What you've
been trying is sort-of a Windows networking path. Odd that pgAdmin
doesn't give an error though.
If you were using psql you'd type something like:
psql -h <ip-addr> -U <username> -d <dbname>
Once you're happy the ip-address is working, try just the server-name by
itself. You'll want the internet name for the machine which in theory
can be different from the Windows network name, but usually is the same.
--
Richard Huxton
Archonet Ltd
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2011-09-16 07:52:24 | Re: PostgreSQL 9.1.0 bug? |
Previous Message | Alban Hertroys | 2011-09-16 06:45:47 | Re: Apparent Problem With NULL in Restoring pg_dump |