Re: Migrating tables to new schema with minimal downtime

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

To: Joseph Hammerman <joe.hammerman@xxxxxxxxxxxxx>
Subject: Re: Migrating tables to new schema with minimal downtime
From: hubert depesz lubaczewski <depesz@xxxxxxxxxx>
Date: Tue, 7 Mar 2023 12:59:58 +0100
Cc: pgsql-admin@xxxxxxxxxxxxxxxxxxxx
In-reply-to: <CAHs7QM8aCJ_a=Rcf=eYAS27eY9Ue6NV5CO+00+ZJnRWbSbxgVg@mail.gmail.com>
References: <CAHs7QM8aCJ_a=Rcf=eYAS27eY9Ue6NV5CO+00+ZJnRWbSbxgVg@mail.gmail.com>
Reply-to: depesz@xxxxxxxxxx

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

References:
- Migrating tables to new schema with minimal downtime
  - From: Joseph Hammerman

Prev by Date: Re: Migrating tables to new schema with minimal downtime
Next by Date: Replication between two different versions
Previous by thread: Re: Migrating tables to new schema with minimal downtime
Next by thread: Replication between two different versions
Index(es):
- Date
- Thread

[Index of Archives] [Postgresql Home] [Postgresql General] [Postgresql Performance] [Postgresql PHP] [Postgresql Jobs] [PHP Users] [PHP Databases] [PHP Home] [PHP on Windows] [Kernel Newbies] [PHP Classes] [PHP Databases] [Yosemite Forum]

Powered by Linux