Re: CREATE DATABASE command concurrency

From: Muhammad Usman Khan <usman(dot)k(at)bitnine(dot)net>
To: Wizard Brony <wizardbrony(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: CREATE DATABASE command concurrency
Date: 2024-09-19 03:53:13
Message-ID: CAPnRvGtkSkpEM-z7SfUtvTDa+15b_e2ttqLMLXDDkrS23jC8Eg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
In PostgreSQL, it's safe to run CREATE DATABASE at the same time from
different places. If two commands try to create the same database, one will
succeed, and the other will safely fail without causing any problems or
incomplete database creation.

On Wed, 18 Sept 2024 at 19:08, Wizard Brony <wizardbrony(at)gmail(dot)com> wrote:

> What are the concurrency guarantees of the CREATE DATABASE command? For
> example, is the CREATE DATABASE command safe to be called concurrently such
> that one command succeeds and the other reliably fails without corruption?
>
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Lok P 2024-09-19 05:30:47 How batch processing works
Previous Message Adrian Klaver 2024-09-18 21:32:48 Re: IO related waits