Postgres Pro
Downloads
Home   >   mailing lists

Re: Migrating tables to new schema with minimal downtime - Mailing list pgsql-admin

From hubert depesz lubaczewski
Subject Re: Migrating tables to new schema with minimal downtime
Date
Msg-id ZAcnPjgwX4zF5QXf@depesz.com
Whole thread Raw
In response to Migrating tables to new schema with minimal downtime  (Joseph Hammerman <joe.hammerman@datadoghq.com>)
List pgsql-admin
Tree view 
On Mon, Mar 06, 2023 at 01:00:15PM -0800, Joseph Hammerman wrote:
> Would it be data safe if I took an ACCESS EXCLUSIVE lock on the table?

alter table gets ACCESS EXCLUSIVE lock on its own.

You can test it trivially in psql on some side table.

Best regards,

depesz

pgsql-admin by date:

Previous
From: Laurenz Albe
Date:
Subject: Re: Migrating tables to new schema with minimal downtime
Next
From: Erik Serrano
Date:
Subject: Replication between two different versions