Re: libpq CREATE DATABASE operation from multiple treads

From: Rob Sargent <robjsargent(at)gmail(dot)com>
To: p(dot)sun(dot)fun(at)gmail(dot)com
Cc: pgsql-sql(at)lists(dot)postgresql(dot)org
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Date: 2020-10-08 20:35:16
Message-ID: 96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

> 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. 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 Tom Lane 2020-10-08 20:36:09 Re: libpq CREATE DATABASE operation from multiple treads
Previous Message Tom Lane 2020-10-08 20:32:28 Re: libpq CREATE DATABASE operation from multiple treads