Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible

Поиск
Список
Период
Сортировка
Искать
От
Michael Paquier
Тема
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible
Дата
Msg-id
aLuKa8FWd_uMPzSg@paquier.xyz
Ответ на
Список
Дерево обсуждения
pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier <michael@paquier.xyz>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier <michael@paquier.xyz>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier <michael@paquier.xyz>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier <michael@paquier.xyz>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Hannu Krosing <hannuk@google.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Andres Freund <andres@anarazel.de>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Michael Paquier <michael@paquier.xyz>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Hannu Krosing <hannuk@google.com>
Re: pg_upgrade: transfer pg_largeobject_metadata's files when possible Nathan Bossart <nathandbossart@gmail.com>
On Fri, Sep 05, 2025 at 01:12:49PM -0500, Nathan Bossart wrote:
> How does this look?

+    # We can only test security labels if both the old and new installations
+    # have dummy_seclabel.
+    my $test_seclabel = 1;
+    $old->start;
+    if (!$old->check_extension('dummy_seclabel'))
+    {
+        $test_seclabel = 0;
+    }
+    $old->stop;
+    $new->start;
+    if (!$new->check_extension('dummy_seclabel'))
+    {
+        $test_seclabel = 0;
+    }
+    $new->stop;

Yep.  This plan is safe to rely on.

A tiny comment I may have is that the LO numbers are hardcoded and
duplicated.  I would have used a variable to store these numbers.
Please feel free to ignore my picky-ism.
--
Michael
В списке pgsql-hackers по дате отправления
От: Michael Paquier
Дата:
От: Michael Paquier
Дата:
FAQ