Yes it shows only one server on the remote computer.
I can send the table as an sql dump if the list will accept an attachment.
The dumped table contains the geom information that I can't see on the
remote connection.
I restored that same dumped table into a different local database. Somewhere
in the restore process those geoms somehow got lost.
Taken all together it does seem as if there is something wrong with the geom
information. Even to my uneducated eye they look strange compared to the
others in the table.
Four of the problem fields represent arrow heads. The fifth is a point.
Bob
-----Original Message-----
From: Adrian Klaver
Sent: Thursday, April 21, 2011 7:22 PM
To: pgsql-general@postgresql.org
Cc: Bob Pawley ; Scott Marlowe
Subject: Re: [GENERAL] Different views of remote server
On Thursday, April 21, 2011 9:24:57 am Bob Pawley wrote:
> Hi Scott
>
> According to NSAuditor(www.nsauditor.com) there is only one server with
> port 5432.
>
> When I enter information into the remote database it shows up on the same
> database that has this problem.
>
> How do I determine my 'connection credentials'?
In pgAdmin they will be in the server properties. Look to see if you are
connecting to a port other than 5432.
>
> Bob
>
--
Adrian Klaver
adrian.klaver@gmail.com
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general