On Thu, 2004-10-21 at 02:44, Iain wrote: > Hi, > > I thought I read something about this in relation to v8, but I can't > find any reference to it now... is it (or will it be) possible to do > master-slave style database replication by transmitting log files to the > standby server and having it process them? >
I'm not certain if this is 8.0, but some folks have created a working version against the 8.0 code that will do something like this. Search the pgsql-hacker mail list archives for more information on it. > Also, just out of interest, if I wanted to mine my log files so as to be > able to produce SQL would that be feasible? Presumably pg does something > like this internally for rollforward recovery, so I guess it would be > possible. > If you want real SQL, you'll need to turn on SQL logging in postgresql.conf. Robert Treat -- Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://archives.postgresql.org