| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Jeff Adams <Jeff(dot)Adams(at)noaa(dot)gov> |
| Cc: | 'Richard Huxton' <dev(at)archonet(dot)com>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Remote connection shows localhost databases |
| Date: | 2011-09-15 21:40:48 |
| Message-ID: | 1316122849.3666.36.camel@localhost.localdomain |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 \\<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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Richard Broersma | 2011-09-15 22:17:59 | Re: forcing table ownership |
| Previous Message | Darin Perusich | 2011-09-15 21:31:42 | Re: forcing table ownership |