Re: [ADMIN] WAL file creation

2007-06-15 Thread Tom Lane
"Donald Fraser" <[EMAIL PROTECTED]> writes: > Does anybody know if it is possible to create a set of *blank* WAL files = > for PostgreSQL 8.1, knowing that the database was safely shut down and = > all data is in tact? pg_resetxlog regards, tom lane --

[ADMIN] WAL file creation

2007-06-15 Thread Donald Fraser
Does anybody know if it is possible to create a set of *blank* WAL files for PostgreSQL 8.1, knowing that the database was safely shut down and all data is in tact? The reason is that during the weekend I failed our master database over to our disaster recovery site, put that in read only mode,