From: Сергей Шиндерук <s.shinderuk@postgrespro.ru>
To: s.shinderuk@postgrespro.ru
To: pgsql-bugs@lists.postgresql.org
Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
Date: Thu, 12 Nov 2026 09:51:45 +0300
Message-ID: <E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru> (raw)
In-Reply-To: <19894-9d785d87407234dc@postgresql.org>
References: <19894-9d785d87407234dc@postgresql.org>
> 12 нояб. 2026 г., в 03:49, PG Bug reporting form <noreply@postgresql.org> написал(а):
>
> The following bug has been logged on the website:
>
> Bug reference: 19894
> Logged by: Sergey Shinderuk
> Email address: s.shinderuk@postgrespro.ru
> PostgreSQL version: 17.11
> Operating system: Ubuntu 24.04
> Description:
>
> Hello,
>
> after CREATE DATABASE on a primary
> select * from pg_visibility_map('pg_class')
> blkno | all_visible | all_frozen
> -------+-------------+------------
> 0 | t | t
> 1 | t | t
> 2 | t | t
> 3 | t | t
> 4 | t | t
> 5 | t | t
> 6 | t | t
> 7 | t | t
> 8 | t | t
> 9 | t | t
> 10 | t | t
> 11 | t | t
> 12 | t | t
> 13 | t | t
> (14 rows)
>
> but on a standby:
> blkno | all_visible | all_frozen
> -------+-------------+------------
> 0 | f | f
> 1 | f | f
> 2 | f | f
> 3 | f | f
> 4 | f | f
> 5 | f | f
> 6 | f | f
> 7 | f | f
> 8 | f | f
> 9 | f | f
> 10 | f | f
> 11 | f | f
> 12 | f | f
> 13 | f | f
> (14 rows)
Sorry, looks like it's a known issue:
https://www.postgresql.org/message-id/CAAKRu_bK7oJvtrrzL_V-OHouCWDKyU2-ERv+QvV6XM9Wh2dpUg@mail.gmail...https://www.postgresql.org/message-id/CAAKRu_aaP%3D0GZe%2BD721byOM9Vwjtu94VdAE_em0PNC0r3EK2zg%40mail...
Didn't follow the discussion yet.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-bugs@postgresql.org
Cc: s.shinderuk@postgrespro.ru
Subject: Re: BUG #19894: CREATE DATABASE logs all-zeros visibility map
In-Reply-To: <E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru>
References: <19894-9d785d87407234dc@postgresql.org> <E2B2D02B-F389-4654-87D6-38E39948DD9F@postgrespro.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox