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 |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
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.
**************************************************************************************
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2004-02-02 17:58:16 | Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory |
Previous Message | Thomas Borg Salling | 2004-02-02 17:30:36 | Re: BUG #1072: "$libdir/ascii_and_mic": No such file or directory |