Re: libpq CREATE DATABASE operation from multiple treads

> On Oct 8, 2020, at 2:41 PM, p(dot)sun(dot)fun(at)gmail(dot)com wrote:
>
> 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?

And if you try it again using template1?