Re: WAL archiving not starting at the beginning

Michael Angeletti wrote:
> 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.

I can't answer the question without digging deeper, but I
wonder why you care.  It is not necessary to have all WAL
segments archived, but only the ones after your first base backup.
And you won't be able to make a base backup before you turn
wal_level to "archive" or higher.

Yours,
Laurenz Albe