[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.... Jeffrey D. Adams National Marine Fisheries Service Office of Protected Resources Marine Mammal & Sea Turtle Conservation Division 1315 East West Hwy Building SSMC3 Silver Spring, MD 20910-3282 phone: (301) 427-8434 fax: (301) 713-0376 email: Jeff.Adams@xxxxxxxx -----Original Message----- From: Richard Huxton [mailto:dev@xxxxxxxxxxxx] Sent: Thursday, September 15, 2011 2:50 PM To: Jeff Adams Cc: pgsql-general@xxxxxxxxxxxxxx Subject: Re: Remote connection shows localhost databases 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? -- Richard Huxton Archonet Ltd -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
