WAL log level compatibility - Mailing list pgsql-general

From Andy Lau
Subject WAL log level compatibility
Date
Msg-id CAPnMqr1d+x2frXduMiDVctpC6KRT2KueKfjHH1e0tMyZwfrDxw@mail.gmail.com
Whole thread Raw
Responses Re: WAL log level compatibility  (Bruce Momjian <bruce@momjian.us>)
List pgsql-general
Hi everyone,

Are 'wal_level = archive' vs 'wal_level = hot_standby' ok to mix? For example, let's say I had a PostgreSQL database running and creating WAL logs in the archive level. Then we switch to the hot standby level to support a hot standby, then go back to the archive level, all while uploading WAL logs to the same location. Would PostgreSQL be able to do PITR over this entire span of time?

Thanks!
-Andy

pgsql-general by date:

Previous
From: Soni M
Date:
Subject: Re: Query planner question
Next
From: Ramesh T
Date:
Subject: Re: POWA tool