Le 15/08/2011 13:19, Lille Penguini a écrit :
> I'm developing a web application and would like to apply changes to
> schema structure from one environment -- call it 'development' -- easily
> to others -- 'test' and 'production'. What are the key terms/resources I
> could consult that would guide me to synchronizing structure like this
> in PostgreSQL?
I'm far from being an expert but what I do in such situation is simply
to backup your development environment (after you made your changes and
insert the data), and restore the production environment from this backup.
If you have a large database and need high availability this may not be
the right option.
In response to
pgsql-novice by date
|Next:||From: bmcmillan||Date: 2011-08-16 20:23:30|
|Subject: Table Trouble|
|Previous:||From: Brent Dombrowski||Date: 2011-08-16 13:46:43|
|Subject: Re: postgresql / osx lion|