From: | "Shoaib Mir" <shoaibmir(at)gmail(dot)com> |
---|---|
To: | "Luca Ferrari" <fluca1978(at)infinito(dot)it> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: schema synchronization |
Date: | 2006-11-13 13:20:31 |
Message-ID: | bf54be870611130520l3b7060bn84b771d5ca0898fe@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Slony might help you there with the EXECUTE SCRIPT option.
Thanks,
---------
Shoaib Mir
EnterpriseDB (www.enterprisedb.com)
On 11/13/06, Luca Ferrari <fluca1978(at)infinito(dot)it> wrote:
>
> Hi all,
> I've got a productional database that is running, while on my laptop I use
> a
> copy of the database to develop an application. Sometimes I have to change
> the schema of the database in order to implement new application features,
> and I'd like to know if there's a way to automatically synchronize the
> schema
> of my laptop (latest) with the productional one. Of course, the changes I
> made does not affect primary or foreign keys or other constraints (i.e., I
> add a column, ...).
> Is this possible?
>
> Thanks,
> Luca
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
From | Date | Subject | |
---|---|---|---|
Next Message | Marko Rihtar | 2006-11-13 13:20:55 | SQL - update table problem... |
Previous Message | Luca Ferrari | 2006-11-13 13:09:58 | schema synchronization |