John wrote:
Hi,
I have a development DB and a production DB. I need a way to sync the changes
I make to the stucture in the devel DB to the production DB. I found pgdiff
but can't get it to work. I would like a solution that would work on windows
and linux. But I'll take either alone.
postgres 8.3
openSUSE 11.0
windows XP/vista
we make our changes via .sql files, and always keep in parallel a 'new
database' .sql file that creates the schema from scratch, and a 'delta'
SQL file which updates from one released version to the next. these
.sql files live in our source code control, along with the applications.
We do _not_ diddle the development environment schema interactively,
except for experiments on a scratch copy.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
