Re: CREATE DATABASE command concurrency - Mailing list pgsql-general

From Muhammad Usman Khan
Subject Re: CREATE DATABASE command concurrency
Date
Msg-id CAPnRvGtkSkpEM-z7SfUtvTDa+15b_e2ttqLMLXDDkrS23jC8Eg@mail.gmail.com
Whole thread Raw
In response to CREATE DATABASE command concurrency  (Wizard Brony <wizardbrony@gmail.com>)
List 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@gmail.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?


pgsql-general by date:

Previous
From: Adrian Klaver
Date:
Subject: Re: IO related waits
Next
From: Lok P
Date:
Subject: How batch processing works