Horton

Re: warning to publication created and wal_level is not set to logical

Lucas Viecelli <lviecelli199@gmail.com>

View thread View on postgr.es
From: Lucas Viecelli <lviecelli199@gmail.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Andres Freund <andres@anarazel.de>, Robert Haas <robertmhaas@gmail.com>, David Fetter <david@fetter.org>, "pgsql-hackers@postgresql.org" <pgsql-hackers@postgresql.org>
Date: 2019-03-26T12:36:10Z
Lists: pgsql-hackers 
>> One idea that might be useful is to have walsenders refuse to transmit
> >> any logical-replication data if they see wal_level is too low.  That
> >> would get users' attention pretty quickly.
>
> > They do:
>

I checked this before creating the patch


>
> Oh, OK, then this seems like it's basically covered already.  I think
> the original suggestion to add a WARNING during CREATE PUBLICATION
> isn't unreasonable.  But we don't need to do more than that (and it
> shouldn't be higher than WARNING).
>

Okay, I think it will improve understanding of new users.

Since everything is fine, thank you all for the comments
-- 

Atenciosamente.

*Lucas Viecelli*

<http://www.leosoft.com.br/coopcred>

Commits

  1. Warn if wal_level is too low when creating a publication.