Re: Soundness of strategy for detecting locks acquired by DDL statements

2025-05-06 Thread Laurenz Albe
On Wed, 2025-05-07 at 06:08 +0300, Agis wrote: > On Wed, May 7, 2025, 00:57 Laurenz Albe wrote: > > On Tue, 2025-05-06 at 12:06 +0300, Agis Anastasopoulos wrote: > > > I'd like to "preflight" a given schema migration (i.e. one or > > > more DDL statements) before applying it to the production dat

Re: Soundness of strategy for detecting locks acquired by DDL statements

2025-05-06 Thread Laurenz Albe
On Tue, 2025-05-06 at 12:06 +0300, Agis Anastasopoulos wrote: > I'd like to "preflight" a given schema migration (i.e. one or > more DDL statements) before applying it to the production database (e.g. > for use in a CI pipeline). I'm thinking of a strategy and would like to > know about its soun

Re: Soundness of strategy for detecting locks acquired by DDL statements

2025-05-06 Thread Achilleas Mantzios
On 6/5/25 12:06, Agis Anastasopoulos wrote: Hello! I'd like to "preflight" a given schema migration (i.e. one or more DDL statements) before applying it to the production database (e.g. for use in a CI pipeline). I'm thinking of a strategy and would like to know about its soundness. The gene

Re: Soundness of strategy for detecting locks acquired by DDL statements

2025-05-06 Thread Adrian Klaver
On 5/6/25 2:06 AM, Agis Anastasopoulos wrote: Hello! I'd like to "preflight" a given schema migration (i.e. one or more DDL statements) before applying it to the production database (e.g. for use in a CI pipeline). I'm thinking of a strategy and would like to know about its soundness. Do y

Soundness of strategy for detecting locks acquired by DDL statements

2025-05-06 Thread Agis Anastasopoulos
Hello! I'd like to "preflight" a given schema migration (i.e. one or more DDL statements) before applying it to the production database (e.g. for use in a CI pipeline). I'm thinking of a strategy and would like to know about its soundness. The general idea is: - you have a test database that'

pgdg-redhat-repo-42.0-52PGDG.noarch.rpm missing

2025-05-06 Thread Matthew Dennison
Hi Receiving the below error this morning when building out a container image using the Official Repo: [MIRROR] pgdg-redhat-repo-42.0-52PGDG.noarch.rpm: Status code: 404 for https://download.postgresql.org/pub/repos/yum/common/redhat/rhel-8-x86_64/pgdg-redhat-repo-42.0-52PGDG.noarch.rpm (IP: 15