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

From Lonni J Friedman
Subject Re: Pg database, need a solution to a problem
Date
Msg-id 7c1574a905013009034a4cb00@mail.gmail.com
Whole thread Raw
In response to Re: Pg database, need a solution to a problem  (Robert Treat <xzilla@users.sourceforge.net>)
List pgsql-general
On Sun, 30 Jan 2005 11:56:04 -0500, Robert Treat
<xzilla@users.sourceforge.net> wrote:
> On Friday 28 January 2005 15:42, Joshua D. Drake wrote:
> > > 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
> >
>
> Since you may not want to have real time replication going (don't push up new
> test cases until they make it out of test), I wonder if something like Robert
> Kaye's lazy replication system he uses for music brainz might be more
> applicable.  I can't recall if his OSCon talk is linked from techdocs, but it
> should be available on the OSCon 2004 site.  Google on some of the above
> words to find out more info.

http://conferences.oreillynet.com/cs/os2004/view/e_sess/5480

Unfortunately, the actual


--
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
L. Friedman                                    netllama@gmail.com
LlamaLand                       http://netllama.linux-sxs.org

pgsql-general by date:

Previous
From: Robert Treat
Date:
Subject: Re: Pg database, need a solution to a problem
Next
From: Ralph Graulich
Date:
Subject: Re: Rule problem with OLD / NEW record set (repost)