Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size

From: Peter Smith <smithpb2250(at)gmail(dot)com>
To: Shubham Khanna <khannashubham1197(at)gmail(dot)com>
Cc: "Hayato Kuroda (Fujitsu)" <kuroda(dot)hayato(at)fujitsu(dot)com>, vignesh C <vignesh21(at)gmail(dot)com>, PostgreSQL Hackers <pgsql-hackers(at)lists(dot)postgresql(dot)org>
Subject: Re: Log a warning in pg_createsubscriber for max_slot_wal_keep_size
Date: 2025-01-10 01:26:04
Message-ID: CAHut+Pszk61QM+cEvq_1-A2y+JrAD0USB+NvtcidajYOfHDkyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi Shubham,

Some review comments for patch v8=0001.

======
Commit message.

1.
By ensuring 'max_slot_wal_keep_size' is -1, this patch prevents the potential
deletion of required WAL files on the publisher that could disrupt logical
replication. A test case has been added to validate correct warning reporting
when 'max_slot_wal_keep_size' is misconfigured.

~

AFAIK the patch only logs a warning. It is not *enforcing* anything at all.

So, saying "ensuring" and "preventing" is misleading.

======
src/bin/pg_basebackup/pg_createsubscriber.c

check_publisher:

2.
+ max_slot_wal_keep_size = strtoi64(PQgetvalue(res, 0, 6), NULL, 0);

Is passing base 0 here ok?

======
src/bin/pg_basebackup/t/040_pg_createsubscriber.pl

3.
+# reload configuration
+$node_p->append_conf('postgresql.conf', 'max_slot_wal_keep_size = 10MB');
+$node_p->reload;
+
+# dry run mode on node S and verify the warning message for misconfigured
+# 'max_slot_wal_keep_size'
+command_checks_all(

Because of the --verbose I expected to see the pg_log_debug message
getting output showing the large (10MB) value for
max_slot_wal_keep_size.

But, I can only see a value of -1 in the log file
'tmp_check/log/regress_log_040_pg_createsubscriber', which may not
even be from the same test. Am I looking in the wrong place (???) e.g.
Where is the logging evidence of that publisher's bad GUC (10MB) value
in the logs before the warning is emitted?

======
Kind Regards,
Peter Smith.
Fujitsu Australia

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message wenhui qiu 2025-01-10 01:45:42 Re: New GUC autovacuum_max_threshold ?
Previous Message Tom Lane 2025-01-10 01:21:04 Re: IANA timezone abbreviations versus timezone_abbreviations