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

createdb fails

From: "Hamedany, Allen" <Allen(dot)Hamedany(at)revivio(dot)com>
To: <pgsql-bugs(at)postgresql(dot)org>
Subject: createdb fails
Date: 2004-02-02 17:53:56
Message-ID: 07FBB852E7D37D4F95879AF229258FF698ABDA@washington.revivio.com (view raw or flat)
Thread:
Lists: pgsql-bugs
Hi,

 

Running postgresql v7.3 on RH7.3 linux; db creation fails and is
reproducible after a fresh image install. Any subsequent rebooting seems
to work fine.

We start up Postgres, create users and db using a Java (IBM1.4.1) class.
The following commands are executed in the following order:

 

/usr/local/pgsql/bin/pg_ctl -w start -D /var/lib/pgsql -l
/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.
**************************************************************************************


Responses

pgsql-bugs by date

Next:From: Tom LaneDate: 2004-02-02 17:58:16
Subject: Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory
Previous:From: Thomas Borg SallingDate: 2004-02-02 17:30:36
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