Postgres Pro
Downloads
Home   >   mailing lists

Comparing two (largish) tables on different servers - Mailing list pgsql-sql

From Gregory S. Williamson
Subject Comparing two (largish) tables on different servers
Date
Msg-id 71E37EF6B7DCC1499CEA0316A256832801D4BAB0@loki.wc.globexplorer.net
Whole thread Raw
Responses Re: Comparing two (largish) tables on different servers  (Pierre-Frédéric Caillaud<lists@boutiquenumerique.com>)
Re: Comparing two (largish) tables on different servers  (Sam Mason <sam@samason.me.uk>)
List pgsql-sql
Tree view 
This is probably a silly question.

Our runtime deployment of database servers (7.4) involves some redundant/duplicate databases. In order to compare
tables(about 5 gigs each) on different servers I unload the things (takes a while etc.), sort them with a UNIX sort and
thendo a cksum on them. 

Is there any way to do this from inside postgres that anyone knows of ? I looked through the manual and the contrib
stuffand didn't see much ...   

Thanks,

Greg Williamson
DBA
GlobeXplorer LLC

pgsql-sql by date:

Previous
From: "andre.toscano"
Date:
Subject: Aggregate like AVG() with Money Data Type
Next
From: Pierre-Frédéric Caillaud
Date:
Subject: Re: Comparing two (largish) tables on different servers