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

Re: createdb fails

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Hamedany, Allen" <Allen(dot)Hamedany(at)revivio(dot)com>
Cc: <pgsql-bugs(at)postgresql(dot)org>
Subject: Re: createdb fails
Date: 2004-02-03 08:12:43
Message-ID: Pine.LNX.4.33.0402021912150.3779-100000@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-bugs
> /var/log/pgsqld.log -o -i
>
>
>
> /usr/local/pgsql/bin/createdb management <-- fails here
>
> /usr/local/pgsql/bin/createdb test <-- fails here
>
>
>
>
>
> Any help on what's causing this behavior and how to fix is appreciated.
>
>
>
> -Allen
>
>
>
>
>
>
>
> +=======================================================================
> ===================+
>
> pgsqld.log:
>
>
>
> 2004-02-02 17:33:00 [1555]   LOG:  database system is ready
>
> 2004-02-02 17:33:01 [1557]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1557]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1557]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1557]   LOG:  duration: 0.035097 sec
>
> 2004-02-02 17:33:01 [1557]   LOG:  query: SELECT d.datname as "Name",
>
>        u.usename as "Owner",
>
>        pg_catalog.pg_encoding_to_char(d.encoding) as "Encoding"
>
> FROM pg_catalog.pg_database d
>
>   LEFT JOIN pg_catalog.pg_user u ON d.datdba = u.usesysid
>
> ORDER BY 1;
>
> 2004-02-02 17:33:01 [1557]   LOG:  duration: 0.024846 sec
>
> 2004-02-02 17:33:01 [1596]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1596]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1596]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1596]   LOG:  duration: 0.000521 sec
>
> 2004-02-02 17:33:01 [1596]   LOG:  query: SET autocommit TO 'on';CREATE
> DATABASE "management"
>
> 2004-02-02 17:33:01 [1621]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1621]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1621]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1621]   LOG:  duration: 0.000509 sec
>
> 2004-02-02 17:33:01 [1621]   LOG:  query: SET autocommit TO 'on';CREATE
> USER "management" CREATEDB CREATEUSER
>
> 2004-02-02 17:33:01 [1626]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1626]   LOG:  connection authorized: user=pgsql
> database=template1
>
> 2004-02-02 17:33:01 [1626]   LOG:  query: begin; select
> getdatabaseencoding(); commit
>
> 2004-02-02 17:33:01 [1626]   LOG:  duration: 0.000509 sec
>
> 2004-02-02 17:33:01 [1626]   LOG:  query: SET autocommit TO 'on';CREATE
> DATABASE "test"
>
> 2004-02-02 17:33:01 [1626]   ERROR:  CREATE DATABASE: source database
> "template1" is being accessed by other users
>
> 2004-02-02 17:33:01 [1631]   LOG:  connection received: host=[local]
>
> 2004-02-02 17:33:01 [1631]   LOG:  connection authorized: user=pgsql
> database=management
>
> **************************************************************************************
> This email message and any files transmitted with it contain confidential information intended only for the person(s) to whom this email message is addressed. If you have received this email message in error, please notify the sender immediately by telephone or email and destroy the original message without making a copy. Thank you.
> **************************************************************************************
>
>
>



In response to

pgsql-bugs by date

Next:From: Kris JurkaDate: 2004-02-03 11:49:59
Subject: Re: createdb fails
Previous:From: Thomas Borg SallingDate: 2004-02-02 21:55:01
Subject: Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory

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