Re: pgsql: Report progress of startup operations that take a long time.

2021-10-29 Thread Robert Haas
On Fri, Oct 29, 2021 at 5:23 PM Alvaro Herrera wrote: > I noticed that the docs for this don't mention the default value and how > can it be changed. I propose something like the attached, where I also > change the order of things so that the example is in a separate > paragraph and the reference

Re: pgsql: Report progress of startup operations that take a long time.

2021-10-29 Thread Alvaro Herrera
On 2021-Oct-25, Robert Haas wrote: > Report progress of startup operations that take a long time. I noticed that the docs for this don't mention the default value and how can it be changed. I propose something like the attached, where I also change the order of things so that the example is in a

pgsql: Fix race condition in startup progress reporting.

2021-10-29 Thread Robert Haas
Fix race condition in startup progress reporting. Commit 9ce346eabf350a130bba46be3f8c50ba28506969 added startup progress reporting, but begin_startup_progress_phase has a race condition: the timeout for the previous phase might fire just before we reschedule the interrupt for the next phase. To a

pgsql: When fetching WAL for a basebackup, report errors with a sensibl

2021-10-29 Thread Robert Haas
When fetching WAL for a basebackup, report errors with a sensible TLI. The previous code used ThisTimeLineID, which need not even be initialized here, although it usually was in practice, because pg_basebackup issues IDENTIFY_SYSTEM before calling BASE_BACKUP, and that initializes ThisTimeLineID a

pgsql: Demote pg_unreachable() in heapam to an assertion.

2021-10-29 Thread Peter Geoghegan
Demote pg_unreachable() in heapam to an assertion. Commit d168b66682, which overhauled index deletion, added a pg_unreachable() to the end of a sort comparator used when sorting heap TIDs from an index page. This allows the compiler to apply optimizations that assume that the heap TIDs from the i

pgsql: Demote pg_unreachable() in heapam to an assertion.

2021-10-29 Thread Peter Geoghegan
Demote pg_unreachable() in heapam to an assertion. Commit d168b66682, which overhauled index deletion, added a pg_unreachable() to the end of a sort comparator used when sorting heap TIDs from an index page. This allows the compiler to apply optimizations that assume that the heap TIDs from the i

pgsql: Test and document the behavior of initialization cross-refs in p

2021-10-29 Thread Tom Lane
Test and document the behavior of initialization cross-refs in plpgsql. We had a test showing that a variable isn't referenceable in its own initialization expression, nor in prior ones in the same block. It *is* referenceable in later expressions in the same block, but AFAICS there is no test cas

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update time zone data files to tzdata release 2021e.

2021-10-29 Thread Tom Lane
Update time zone data files to tzdata release 2021e. DST law changes in Fiji, Jordan, Palestine, and Samoa. Historical corrections for Barbados, Cook Islands, Guyana, Niue, Portugal, and Tonga. Also, the Pacific/Enderbury zone has been renamed to Pacific/Kanton. The following zones have been mer

pgsql: Update SELinux links in sepgsql documentation

2021-10-29 Thread Daniel Gustafsson
Update SELinux links in sepgsql documentation The SELinux FAQ and User Guide links has been redirecting from the URL in our documentation for a very long time (since 2011 according to archive.org), but the redirect is no longer maintained and they now return a 404 since some time back. Fix by rep