Re: libpq CREATE DATABASE operation from multiple treads

From: p(dot)sun(dot)fun(at)gmail(dot)com
To: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Date: 2020-10-08 20:41:01
Message-ID: e11780112264fddbae35f53a3b26095f1789e413.camel@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Thu, 2020-10-08 at 14:35 -0600, Rob Sargent wrote:
> > On Oct 8, 2020, at 2:30 PM, p(dot)sun(dot)fun(at)gmail(dot)com wrote:
> >
> > Indeed, this is a FATAL_ERROR. From two threads I got:
> >
> > // Thread #1
> > FATAL_ERROR: ERROR: source database "template1" is being accessed
> > by
> > other users
> > DETAIL: There is 1 other session using the database.
> >
> > // Thread #2
> > FATAL_ERROR: ERROR: source database "template1" is being accessed
> > by
> > other users
> > DETAIL: There is 1 other session using the database.
> >
> I would try using dbname=postgres.
aaaaand.... it works. Two databases have been created with return
status "COMMAND_OK".

> If you get the same error, I would say your server is in single user
> mode?
>

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Rob Sargent 2020-10-08 20:43:45 Re: libpq CREATE DATABASE operation from multiple treads
Previous Message Tom Lane 2020-10-08 20:36:09 Re: libpq CREATE DATABASE operation from multiple treads