Re: libpq CREATE DATABASE operation from multiple treads - Mailing list pgsql-sql

From Rob Sargent
Subject Re: libpq CREATE DATABASE operation from multiple treads
Date
Msg-id 058A9601-35F6-42C1-AC4C-8DD4643E418F@gmail.com
Whole thread Raw
In response to Re: libpq CREATE DATABASE operation from multiple treads  (p.sun.fun@gmail.com)
Responses Re: libpq CREATE DATABASE operation from multiple treads
List pgsql-sql


On Oct 8, 2020, at 2:41 PM, p.sun.fun@gmail.com wrote:

On Thu, 2020-10-08 at 14:35 -0600, Rob Sargent wrote:
On Oct 8, 2020, at 2:30 PM, p.sun.fun@gmail.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?

And if you try it again using template1?

pgsql-sql by date:

Previous
From: p.sun.fun@gmail.com
Date:
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Next
From: p.sun.fun@gmail.com
Date:
Subject: Re: libpq CREATE DATABASE operation from multiple treads