Matthew Tedder dijo: > On Friday 14 June 2002 04:41 pm, Bill Cunningham wrote: > > Matthew Tedder wrote:
> > > How feasible would it be to create this functionality in PostgreSQL: > > > > > >One creates a test version of a database that initially consists of > > >read-links to the production version of the same database. Any code > > > he/she then writes that reads from a table reads from the production > > > database but any code that modifies data copies that table to the test > > > database. > > [pg_dump into the development machines] > That won't work nearly as well. Obviously we can and often do dumps. But > when testing something that has to work in a production environment, we need > to see what happens over a course of several day's time. This is needed not > only for testing of the specific code changed or added to a process, but also > a test of how it integrations with a larger and more complex information flow > system. Seems like single master multi slave replication would do the trick, wouldn't it? You can replicate the master's data to the slaves and do the tests there. Depending on how frequent the updates are (assuming they are asynchronous), the DB load will be different, but I wonder whether this may be an issue. -- Alvaro Herrera (<alvherre[a]atentus.com>) El sentido de las cosas no viene de las cosas, sino de las inteligencias que las aplican a sus problemas diarios en busca del progreso. (Ernesto Hernández-Novich) ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
