Re: why do we allow people to create a publication before setting wal_leve

From: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
To: Dave Cramer <davecramer(at)gmail(dot)com>
Cc: PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: why do we allow people to create a publication before setting wal_leve
Date: 2020-07-02 23:58:22
Message-ID: 20200702235822.4whr2f2ayolkbbtm@development
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

On Thu, Jul 02, 2020 at 12:37:29PM -0400, Dave Cramer wrote:
>This seems pretty strange:
>
>create publication pub1 for all tables;
>
> WARNING: wal_level is insufficient to publish logical changes
>HINT: Set wal_level to logical before creating subscriptions.
>

pg_dump restoring a database with publications would fail unnecessarily.

There's a more detailed explanation in the thread that ultimately added
the warning in 2019:

https://www.postgresql.org/message-id/flat/CAPjy-57rn5Y9g4e5u--eSOP-7P4QrE9uOZmT2ZcUebF8qxsYhg%40mail.gmail.com

regards

--
Tomas Vondra http://www.2ndQuadrant.com
PostgreSQL Development, 24x7 Support, Remote DBA, Training & Services

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Tomas Vondra 2020-07-03 00:57:37 Re: WIP: BRIN multi-range indexes
Previous Message Bruce Momjian 2020-07-02 23:06:47 Re: Enabling B-Tree deduplication by default