Search Postgresql Archives

Re: Remote connection shows localhost databases

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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 \\<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.
> 

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
likely try to connect locally.

> 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.
> 


-- 
Guillaume
  http://blog.guillaume.lelarge.info
  http://www.dalibo.com


-- 
Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux