Re: Postgres Backup Utility - Mailing list pgsql-admin

From John DeSoi
Subject Re: Postgres Backup Utility
Date
Msg-id B51575A9-7BA1-4ADD-B152-38B32CD0C015@pgedit.com
Whole thread Raw
In response to Re: Postgres Backup Utility  ("Bradley Holbrook" <operations_bradley@servillian.ca>)
Responses Re: Postgres Backup Utility
List pgsql-admin
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'tthat kind of difference matter when you want to apply the changes to your production database? 



John DeSoi, Ph.D.





pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: binary logs: a location other than pg_xlog??
Next
From: Scott Marlowe
Date:
Subject: Re: Postgres Backup Utility