Re: Pg database, need a solution to a problem

> 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(at)postgresql(dot)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