X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org
Received: from localhost (unknown [200.46.204.144])
	by svr1.postgresql.org (Postfix) with ESMTP id E06685638F;
	Mon,  7 Mar 2005 13:41:09 +0000 (GMT)
Received: from svr1.postgresql.org ([200.46.204.71])
	by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024)
	with ESMTP id 57881-07; Mon,  7 Mar 2005 13:41:04 +0000 (GMT)
Received: from ucsns.ucs.co.za (ucs.co.za [196.23.43.2])
	by svr1.postgresql.org (Postfix) with ESMTP id 25E45563FC;
	Mon,  7 Mar 2005 13:40:58 +0000 (GMT)
Received: from ucspost.ucs.co.za (mailgw1.ucs.co.za [196.23.43.253])
	by ucsns.ucs.co.za (Postfix) with ESMTP id 133442BD67;
	Mon,  7 Mar 2005 15:40:50 +0200 (SAST)
Received: from jhb.ucs.co.za (jhb.ucs.co.za [172.31.1.3])
	by ucspost.ucs.co.za (Postfix) with ESMTP
	id C749AD9FA2; Mon,  7 Mar 2005 15:40:51 +0200 (SAST)
Received: from svb.ucs.co.za (svb.ucs.co.za [172.31.1.148])
	by jhb.ucs.co.za (Postfix) with ESMTP id 02FAC973EC;
	Mon,  7 Mar 2005 15:40:51 +0200 (SAST)
Date: Mon, 7 Mar 2005 15:40:51 +0200
From: Stef <svb@ucs.co.za>
To: Richard_D_Levine@raytheon.com
Cc: pgsql-ADMIN@postgresql.org, pgsql-sql@postgresql.org,
	pgsql-sql-owner@postgresql.org
Subject: Re: [SQL] Postgres schema comparison.
Message-ID: <20050307154051.0ef66537@svb.ucs.co.za>
In-Reply-To: <OFE329A02A.6AD7CF2E-ON05256FBD.0047B53E@ftw.us.ray.com>
References: <OFE329A02A.6AD7CF2E-ON05256FBD.0047B53E@ftw.us.ray.com>
X-Mailer: Sylpheed-Claws 1.0.1 (GTK+ 1.2.10; i386-pc-linux-gnu)
User-Agent: sillypheed-claws (anti-aliased)
X-Face: +lU/o'$=Zv9%Xjo]Kq[_{n&Kb`f{YE<S+T;
	pGztI>WH4&Y#M]'6BkD?VoWe#*@S\MWyD'I>s:0v4{#\[J]l*?]t2uaO(j$d*77Ca-UHo.tkl2)0$B3Jxww\o:xor]<:*Yfx9Vceh)9I/'2g\RKhGTxIIsR^ke^`LVeZ9ksb*:$kQeR@
X-Operating-System: sid
X-X-X: _-^-_
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.328 tagged_above=0 required=5 tests=AWL,
	DNS_FROM_RFC_WHOIS
X-Spam-Level: 
X-Archive-Number: 200503/80
X-Sequence-Number: 16578

Richard_D_Levine@raytheon.com mentioned :
=> Are you just synching the schemas, or do you also need to synch the data?

Schemas now, data later.

To do the data part, I'm thinking of using slony, because it seems to be able to
do pretty much everything I need from that side. But, unfortunately I can't 
even start fixing the data before the schemas aren't fixed.

Kind Regards
Stefan