Search Postgresql Archives

Re: Remote connection shows localhost databases

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

 



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.
> When I try to connect to the remote machine, I enter \\<server>\<ip_address>
> into the host name field. What I found was it didn't matter what I entered
> into the hostname field (I put in random strings to test), it always brought
> up the databases on the localhost....
> 

In pgAdmin, you have a Name field (which is a description, so free
text), and you have a Host field. The host field should contain the
socket complete path, or the host name, or the ip address. With this,
you're able to connect to any PostgreSQL server, as long as their
pg_hba.conf file allows it.


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