[ADMIN] wal logs in pg_xlog

2005-06-26 Thread Nasir Iqbal Danish
I am using postgres 8.0.3, and wanted to use Point In Time Recovery enable. could any one tell me about how to indentify the current WAL file, also let me know if there is any fix patteren for WAL log file generations. documentaion says it will generate ever increasing number starting from some

Re: [ADMIN] restoring wal archive and pg_xlog dir

2005-06-26 Thread Jeff Frost
On Thu, 23 Jun 2005, Simon Riggs wrote: That was the bit I didn't. Fix partially implemented and I am to submit for 8.1, godspeed my typing fingers. There's a simple workaround if you have a low transaction rate system: load up enough data to trip into the next xlog. I just noticed one other t

Re: [ADMIN] real time replication of pgsql database

2005-06-26 Thread Jim C. Nasby
You should also look at http://pgfoundry.org/projects/pgcluster/ On Sat, Jun 25, 2005 at 11:44:37AM -0400, Christopher Browne wrote: > Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (hellz waren) would > write: > > we are designing a heavy duty database in pgsql that > > expects to gro