minimal wal_level on subscriber

Started by Arnaud L.about 6 years ago5 messagesgeneral
Jump to latest
#1Arnaud L.
arnaud.listes@codata.eu

Hi list,

is it OK to set wal_level to minimal on the subscriber side of the
logical replication ?
Thanks !

Regards
--
Arnaud

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Arnaud L. (#1)
Re: minimal wal_level on subscriber

On Thu, 2020-01-16 at 12:09 +0100, Arnaud L. wrote:

is it OK to set wal_level to minimal on the subscriber side of the
logical replication ?

Yes, if you don't want physical backups.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

#3Arnaud L.
arnaud.listes@codata.eu
In reply to: Laurenz Albe (#2)
Re: minimal wal_level on subscriber

Le 16/01/2020 à 19:58, Laurenz Albe a écrit :

On Thu, 2020-01-16 at 12:09 +0100, Arnaud L. wrote:

is it OK to set wal_level to minimal on the subscriber side of the
logical replication ?

Yes, if you don't want physical backups.

You mean online physical backups ?
I could still shutdown the subscriber and take an offline physical
backup, right ?

Regards
--
Arnaud

#4Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Arnaud L. (#3)
Re: minimal wal_level on subscriber

On Fri, 2020-01-17 at 08:43 +0100, Arnaud L. wrote:

is it OK to set wal_level to minimal on the subscriber side of the
logical replication ?

Yes, if you don't want physical backups.

You mean online physical backups ?
I could still shutdown the subscriber and take an offline physical
backup, right ?

Yes, that is what I mean.

Yours,
Laurenz Albe
--
Cybertec | https://www.cybertec-postgresql.com

#5Arnaud L.
arnaud.listes@codata.eu
In reply to: Laurenz Albe (#4)
Re: minimal wal_level on subscriber

Le 17/01/2020 à 19:07, Laurenz Albe a écrit :

On Fri, 2020-01-17 at 08:43 +0100, Arnaud L. wrote:

is it OK to set wal_level to minimal on the subscriber side of the
logical replication ?

Yes, if you don't want physical backups.

You mean online physical backups ?
I could still shutdown the subscriber and take an offline physical
backup, right ?

Yes, that is what I mean.

Great. Thanks Laurenz !

Regards
--
Arnaud