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 23F4DE61-F81D-4740-A227-74B5EB41304C@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:46 PM, p.sun.fun@gmail.com wrote:
>
> On Thu, 2020-10-08 at 14:43 -0600, Rob Sargent wrote:
>>
>>
>>> 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?
>>
>
> Nope, the same errors:
> // 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.
>
>
>
OK, well that’s a special db.  Didn’t know it was that special, though!




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