Different views of remote server

From: "Bob Pawley" <rjpawley(at)shaw(dot)ca>
To: "Postgresql" <pgsql-general(at)postgresql(dot)org>
Subject: Different views of remote server
Date: 2011-04-20 18:09:59
Message-ID: B1C12643275B4D50A67EE4F49F1308E4@BobPC
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi

This is probably going to turn out to be me doing something stupid, but-

I have two computers, one of which I use as a remote server for my database.

When I connect to the remote database through my interface there are errors that suggest a problem with the data in one of the tables.

Using PgAdmin to view the remote table there is indeed some information missing (5 out of 16 geoms).

When I use the PGAdmin on the remote computer, using a local connection, this information is not missing it is intact.

I don’t think it is a PgAdmin problem because when I do a ‘select the_geom’ as a remote query the information is missing where it is not missing the PgAdmin on the other computer as a local query.

Also connecting to the remote DB using Quantum GIS shows the “missing” information as being present and normal.

I have also checked with a server display app and the appropriate number of servers are present (only one present on the remote computer).

I’ve run out of ideas - Would anyone have any thoughts of what might be going on???

Bob

PS – I have tried one other thing - dumping the database from the remote server and restoring it to the local server and the information (the 5 geoms) goes missing sometime during this transaction.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2011-04-20 19:03:24 Re: REASSIGN OWNED doesn't for all objects, ALTER FUNCTION seems to fix it
Previous Message SUBHAM ROY 2011-04-20 17:11:30 Needs Suggestion