Hi, Thanks Nicolas. That's the path I was thinking of taking. Using a bash script to iteratively query each table for certain information and then write that info to a text file.
That still doesn't answer the transaction part, but I can live without that as long as I find the main differences, if any, between tables. Thanks again. Richard. -----Original Message----- From: postgis-users-boun...@postgis.refractions.net [mailto:postgis-users-boun...@postgis.refractions.net] On Behalf Of Nicolas Ribot Sent: 02 May 2012 13:05 To: PostGIS Users Discussion Subject: Re: [postgis-users] Differences between schemas on different servers Hi, You could use a script (batch, shell...) to query the 2 databases and report informations on each table. Concerning knowing latest transaction on a table, it doe not seem easy to do if triggers do not exist on the table to track down changes. (I may not be right...). NIcolas On 26 April 2012 17:06, White, Richard <richard.wh...@infoterra-global.com> wrote: > Hi, > > I need to compare the differences between 2 postgres database schemas. > > > The schemas are named the same but running on different servers and should > be the same. > > > I want to know if server_1.schema.table is different to > server_2.schema.table with regards to numbers of features in each table and > when the last transaction / update took place on each table. > > > > Thanks. > > > > R. > > > > > > > > > > _______________________________________________ > postgis-users mailing list > postgis-users@postgis.refractions.net > http://postgis.refractions.net/mailman/listinfo/postgis-users > _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users Infoterra Ltd. Is part of the Astrium GEO-Information Services Division and a wholly owned subsidiary of Astrium, Europe's leading space systems and services specialist. Disclaimer. The information contained in this e-mail and its attachments are confidential and intended only for the use of the named addressee(s). If you are not the intended addressee, please do not read, copy, use or disclose this message or its attachments. If you have received this message in error, please notify the sender immediately and delete or destroy all copies of this message and attachments in all media. Any views or opinions expressed are solely those of the author and do not necessarily represent those of Infoterra Ltd and shall not form part of any binding agreement. Infoterra Limited a company registered in England under number 2359955 and having its registered office at Atlas House, 41 Wembley Road, Leicester, LE3 1UT. VAT number GB 476 0468 27. P Before printing, think about the environment _______________________________________________ postgis-users mailing list postgis-users@postgis.refractions.net http://postgis.refractions.net/mailman/listinfo/postgis-users
