Re: schema synchronization

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
>

In response to

Browse pgsql-general by date

  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