agora inbox for pgsql-sql@postgresql.org  

help / color / mirror / Atom feed

From: Rob Sargent <robjsargent@gmail.com>
To: p.sun.fun@gmail.com
Cc: pgsql-sql@lists.postgresql.org
Subject: Re: libpq CREATE DATABASE operation from multiple treads
Date: Thu, 8 Oct 2020 14:35:16 -0600
Message-ID: <96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com> (raw)
In-Reply-To: <124ce8dff8402159f20dec1bc1ac27e26ee39c23.camel@gmail.com>
References: <390804abe88e4e9da9049f6e05c841783acaca47.camel@gmail.com>
	<CAAfz9KOVPRptcva6T97+VgLhYbqMJGC07yHVHMW3Ugxki6y6dA@mail.gmail.com>
	<124ce8dff8402159f20dec1bc1ac27e26ee39c23.camel@gmail.com>



> 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.  If you get the same error, I would say your server is in single user mode?

view thread (18+ messages)  latest in thread

Message-ID: <96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com>
Permalink:  ../96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com/
Also on:    postgresql.org/message-id/96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-sql@postgresql.org
  Cc: robjsargent@gmail.com, p.sun.fun@gmail.com, pgsql-sql@lists.postgresql.org
  Subject: Re: libpq CREATE DATABASE operation from multiple treads
  In-Reply-To: <96718FB0-E258-4342-BD6E-BCE6603BCBD5@gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox