[HACKERS] resetxlog bug
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 still looking for the old file in the pg_xlog directory. Has this bug been fixed in a version beyond 8.3.1? Thanks for your help! pg_resetxlog bug? * *From*: Fujii Masao masao(dot)fujii(at)gmail(dot)com * *To*: PostgreSQL-development pgsql-hackers(at)postgresql(dot)org * *Subject*: pg_resetxlog bug? * *Date*: Fri, 1 May 2009 00:07:26 +0900 * *Message-id*: 3f0b79eb0904300807y43a96717ued641f6624c2...@mail.gmail.com http://archives.postgresql.org/message-id/3f0b79eb0904300807y43a96717ued641f6624c2...@mail.gmail.com text/plain http://archives.postgresql.org/msgtxt.php?id=3f0b79eb0904300807y43a96717ued641f6624c2...@mail.gmail.com
Re: [HACKERS] resetxlog bug
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 corruption in the system catalogs. So you always care about it. -- Alvaro Herrerahttp://www.CommandPrompt.com/ PostgreSQL Replication, Consulting, Custom Development, 24x7 support -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
Re: [HACKERS] resetxlog bug
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 reset the logs and go from there. However, after the pg_resetxlog, PG is still looking for the old file in the pg_xlog directory. Has this bug been fixed in a version beyond 8.3.1? Is that the same problem which was discussed before? If so, that bug fix will be included in the upcoming 8.3.8. http://archives.postgresql.org/message-id/3f0b79eb0904300807y43a96717ued641f6624c2...@mail.gmail.com Regards, -- Fujii Masao NIPPON TELEGRAPH AND TELEPHONE CORPORATION NTT Open Source Software Center -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers