Received: from maia.hub.org (maia-3.hub.org [200.46.204.243])
	by mail.postgresql.org (Postfix) with ESMTP id B03DA1337B4F
	for <pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 14:22:55 -0400 (AST)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.243]) (amavisd-maia,
	port 10024) with ESMTP id 76756-10 for
	<pgsql-admin-postgresql.org@mail.postgresql.org>;
	Sat, 22 Jan 2011 18:22:48 +0000 (UTC)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.6
Received: from mail8.sea5.speakeasy.net (mail8.sea5.speakeasy.net
	[69.17.117.53])
	by mail.postgresql.org (Postfix) with ESMTP id 310D01337B47
	for <pgsql-admin@postgresql.org>; Sat, 22 Jan 2011 14:22:47 -0400 (AST)
Received: (qmail 9563 invoked from network); 22 Jan 2011 18:22:46 -0000
Received: from 25-76-42-72.skybeam.com (HELO [192.168.2.16])
	(scott_ribe@killerbytes.com@[72.42.76.25])
	(envelope-sender <scott_ribe@elevated-dev.com>)
	by mail8.sea5.speakeasy.net (qmail-ldap-1.03) with AES128-SHA encrypted
	SMTP
	for <operations_bradley@servillian.ca>; 22 Jan 2011 18:22:46 -0000
Subject: Re: Postgres Backup Utility
Mime-Version: 1.0 (Apple Message framework v1082)
Content-Type: text/plain; charset=us-ascii
From: Scott Ribe <scott_ribe@elevated-dev.com>
In-Reply-To: <01af01cbb8c9$58eaa0e0$0abfe2a0$@servillian.ca>
Date: Sat, 22 Jan 2011 11:22:45 -0700
Cc: "'Scott Marlowe'" <scott.marlowe@gmail.com>,
	"'French, Martin'" <frenchm@cromwell.co.uk>, <pgsql-admin@postgresql.org>
Content-Transfer-Encoding: quoted-printable
Message-Id: <A24D0F0F-A4DB-4958-83DB-AFBCEB9DE85D@elevated-dev.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-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/150
X-Sequence-Number: 36590

On Jan 20, 2011, at 10:42 AM, Bradley Holbrook wrote:

> Martin French is right though, ask your developers to write down all =
their
> SQL struct changes and they look at you funny... and being a developer
> myself I'd look at me funny.

Well, it's what I do and it's trivial. Just don't type DDL directly into =
a psql session, edit it in your favorite text editor, in a document =
called updates-pending.sql, and copy & paste into psql. Sometimes a tiny =
bit of *process* can actually help productivity ;-)

--=20
Scott Ribe
scott_ribe@elevated-dev.com
http://www.elevated-dev.com/
(303) 722-0567 voice