Thread: minimal wal_level on subscriber
Hi list, is it OK to set wal_level to minimal on the subscriber side of the logical replication ? Thanks ! Regards -- Arnaud
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
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
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
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