[HACKERS] resetxlog bug

2009-07-01 Thread Lorraine Mancuso
Hi, I am currently running PG version 8.3.1. I am working in a test environment. I have a situation where the WAL file needed at startup no longer exists and I really don't care about it, therefore, I just want to reset the logs and go from there. However, after the pg_resetxlog, PG is

Re: [HACKERS] resetxlog bug

2009-07-01 Thread Alvaro Herrera
Lorraine Mancuso wrote: Hi, I am currently running PG version 8.3.1. I am working in a test environment. I have a situation where the WAL file needed at startup no longer exists and I really don't care about it, This is never true -- if you lose a WAL file, there is potential

Re: [HACKERS] resetxlog bug

2009-07-01 Thread Fujii Masao
Hi, On Thu, Jul 2, 2009 at 5:19 AM, Lorraine Mancusomancus...@scranton.edu wrote:    I am currently running PG version 8.3.1. I am working in a test environment. I have a situation where the WAL file needed at startup no longer exists and I really don't care about it, therefore, I just want to