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
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 |