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
Views: Raw Message | Whole Thread | Download mbox | Resend email
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

Browse pgsql-bugs by date

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