Re: Updating a production database schema from dev server

Stanislav Raskin wrote:
>
> I figure there must be a better way to do so. Is there some kind of
> software, which compares two database schemas (preferably two sql dumps),
> and generates a script for applying differences to one of them?
>
> What would be the best practice for applying such updates without
> endangering the data and its integrity?

What Scott said, unfortunately there's no substitute for discipline here.

It's not actually possible to fully automate this (what would it do if
you merged the data in two columns for example). There are some tools to
help you though - try searching for "diff" on www.pgfoundry.org or
"pgdiff" in google.

--
   Richard Huxton
   Archonet Ltd