[postgis-users] Differences between schemas on different servers

[Nicolas Ribot]

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.White at 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.
>
>
>
> 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 at postgis.refractions.net
> http://postgis.refractions.net/mailman/listinfo/postgis-users
>