Skip site navigation (1) Skip section navigation (2)

Bug #824: Problem creating data base !!

From: pgsql-bugs(at)postgresql(dot)org
To: pgsql-bugs(at)postgresql(dot)org
Subject: Bug #824: Problem creating data base !!
Date: 2002-11-28 15:07:25
Message-ID: 20021128150725.A54FD476427@postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
Christian Gonzalez (christiangda(at)cantv(dot)net) reports a bug with a severity of 3
The lower the number the more severe it is.

Short Description
Problem creating data base !!

Long Description
Recently i tried to create a data base via SSH with an user allowed to do it, but it displays the following message:
ERROR:  CREATE DATABASE: source database "template1" is being accessed by other users
createdb: database creation failed

on the other hand, it is possible to create it via pgAdminII. The server running postgresql has this configuration:
-Redhat 8.0
-PostgreSQL 7.2.3

I will apreciate any help on it.

Thanks in advance

Sample Code
[root(at)bdserver root]# su -l postgres 
-bash-2.05b$ createdb prueba
ERROR:  CREATE DATABASE: source database "template1" is being accessed by other users
createdb: database creation failed
-bash-2.05b$ 


No file was uploaded with this report


pgsql-bugs by date

Next:From: Tom LaneDate: 2002-11-28 15:10:59
Subject: Re: timeofday()::timestamp - not casting
Previous:From: pgsql-bugsDate: 2002-11-28 15:07:16
Subject: Bug #824: Problem creating data base !!

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group