Postgres Pro
Downloads
Home   >   mailing lists

Re: Pg database, need a solution to a problem - Mailing list pgsql-general

From Joshua D. Drake
Subject Re: Pg database, need a solution to a problem
Date
Msg-id 41FAA3A0.7040606@commandprompt.com
Whole thread Raw
In response to Pg database, need a solution to a problem  (Adam Wilson <svt_contour@yahoo.com>)
Responses Re: Pg database, need a solution to a problem
List pgsql-general
Tree view 
> Does anyone have any suggestions for how to get the
> testcase id's and suite's replicated to the production
> database with out touching the other tables in there?
> I would just do a pg_dump on selected tables, but
> there are sequences in the DB for adding new suites,
> and testcases and I don't want these getting out of
> sync.  Or can I copy the sequence id's as well so they
> are updated on the production Pg DB?

You could run replication for just the tables you need.
Check out www.slony.info or www.commandprompt.com

Sincerely,

Joshua D. Drake



>
> Thanks
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


--
Command Prompt, Inc., your source for PostgreSQL replication,
professional support, programming, managed services, shared
and dedicated hosting. Home of the Open Source Projects plPHP,
plPerlNG, pgManage,  and pgPHPtoolkit.
Contact us now at: +1-503-667-4564 - http://www.commandprompt.com
Attachment

pgsql-general by date:

Previous
From: "Frank D. Engel, Jr."
Date:
Subject: Re: Moving from Sybase to Postgres - Stored Procedures
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Moving from Sybase to Postgres - Stored Procedures