Received: from maia.hub.org (maia-2.hub.org [200.46.204.251])
	by mail.postgresql.org (Postfix) with ESMTP id 772B61337990
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Thu, 20 Jan 2011 21:08:54 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.251]) (amavisd-maia,
	port 10024) with ESMTP id 53736-07 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Fri, 21 Jan 2011 01:08:47 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from a2s36.a2hosting.com (a2s36.a2hosting.com [216.119.134.130])
	by mail.postgresql.org (Postfix) with ESMTP id 4DAFA13364DE
	for <pgsql-admin@postgresql.org>; Thu, 20 Jan 2011 21:08:47 -0400 (AST)
Received: from adsl-70-99-30.tys.bellsouth.net ([98.70.99.30]
 helo=[10.0.0.18])
	by a2s36.a2hosting.com with esmtpsa (TLSv1:AES128-SHA:128)
	(Exim 4.69) (envelope-from <desoi@pgedit.com>)
	id 1Pg5UZ-0002y1-DT; Thu, 20 Jan 2011 20:08:43 -0500
Subject: Re: Postgres Backup Utility
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: text/plain; charset=us-ascii
From: John DeSoi <desoi@pgedit.com>
In-Reply-To: <01af01cbb8c9$58eaa0e0$0abfe2a0$@servillian.ca>
Date: Thu, 20 Jan 2011 20:08:42 -0500
Cc: "'Scott Marlowe'" <scott.marlowe@gmail.com>,
	"'French, Martin'" <frenchm@cromwell.co.uk>, <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <B51575A9-7BA1-4ADD-B152-38B32CD0C015@pgedit.com>
References: <036101cbb6a3$baa178e0$2fe46aa0$@servillian.ca>
	<81976671721DF04B9DCA6ECD87941A402640812A@roundway.Cromwell-tools.co.uk>
	<004e01cbb730$bdb21930$39164b90$@servillian.ca>
	<81976671721DF04B9DCA6ECD87941A402640863E@roundway.Cromwell-tools.co.uk>
	<AANLkTi=E0EjWKUuxiOyOOmemKYga9Z=5a4iJbsbKX=hE@mail.gmail.com>
	<81976671721DF04B9DCA6ECD87941A40264B2BB5@roundway.Cromwell-tools.co.uk>
	<AANLkTimKC442BHxR3OgMVw=30L-qwTx+vc+SoTdwF6s7@mail.gmail.com>
	<01af01cbb8c9$58eaa0e0$0abfe2a0$@servillian.ca>
To: Bradley Holbrook <operations_bradley@servillian.ca>
X-Mailer: Apple Mail (2.1082)
X-AntiAbuse: This header was added to track abuse,
	please include it with any abuse report
X-AntiAbuse: Primary Hostname - a2s36.a2hosting.com
X-AntiAbuse: Original Domain - postgresql.org
X-AntiAbuse: Originator/Caller UID/GID - [47 12] / [47 12]
X-AntiAbuse: Sender Address Domain - pgedit.com
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=-1.9 tagged_above=-10 required=5 tests=BAYES_00=-1.9
X-Spam-Level: 
X-Archive-Number: 201101/134
X-Sequence-Number: 36574


On Jan 20, 2011, at 12:42 PM, Bradley Holbrook wrote:

> Our developers never decide what goes to where... they just happily =
plumb
> away on the development db until we're ready to take our product to =
testing
> (at regular intervals), once QA is passed, we wish to apply these to =
live.
> We have several diff tools and sync tools, but they take forever =
(especially
> the ones that only go one schema at a time).

Using a diff tool, how would you know if a column was dropped and =
another one added versus simply renaming a column? Won't that kind of =
difference matter when you want to apply the changes to your production =
database?



John DeSoi, Ph.D.