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