WAL archiving not starting at the beginning

From: Michael Angeletti <flashdesignpro(at)gmail(dot)com>
To: "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: WAL archiving not starting at the beginning
Date: 2013-06-22 16:43:47
Message-ID: EFCE90BA-C25D-4DCB-B1D1-C3B6094A6E45@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi pg devs, fellow pg users

I'm Michael, and this is my first post here.

I asked this question last night:

http://dba.stackexchange.com/questions/45077

which details the problem (or not?) I'm having. The gist of it is that Postgres is not archiving the first WAL segments for my cluster. You'll note that I changed the wal_level from "minimal" to "hot_standby" at the same time as I turned archiving on. I'm not sure if A) that's a no-no (changing the wal_level after a new cluster has started once), B) it's a bug/problem to have my archives starting at the 6th log, despite the first 5 still being in pg_xlog, C) if my switching of wal_level has anything to do with the issue, and D) if I need to start over with a fresh database or something, in order to remedy the issue.

Thanks
Michael

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dan Kogan 2013-06-22 19:43:38 Standby stopped working after PANIC: WAL contains references to invalid pages
Previous Message Kevin Grittner 2013-06-22 14:35:36 Re: File System backup