On Sun, 30 Jan 2005 11:56:04 -0500, Robert Treat <xzilla@xxxxxxxxxxxxxxxxxxxxx> 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@xxxxxxxxx LlamaLand http://netllama.linux-sxs.org ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@xxxxxxxxxxxxxx
