Re: sync structures

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.