From: | Dario Brignardello <dbrignar(at)gmail(dot)com> |
---|---|
To: | "Karthik(dot)S" <skarthik(at)midascomm(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: error while creating database |
Date: | 2005-12-06 18:00:57 |
Message-ID: | 45dd8dbe0512061000o674ca409k2b000e94c0ad315@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Greetings:
I may be wrong, but you could try using the createdb / dropdb utils
from the pgsql/bin directory, or calling psql with some of the
parameters used by such tools (-c -d , etc).
Hope it helps.
Best regards
Dario
On 12/6/05, Karthik.S <skarthik(at)midascomm(dot)com> wrote:
> Dear all,
>
> I am using postgres version: 7.1.3 in Red hat linux : 7.2.
>
> I am having a script(uses psql) which drops and creates a database by
> logging
> into 'template1'. This will be invoked from crontab.
>
> Sometimes (nearly 50% of the times) the database creation fails by saying
> "ERROR: CREATE DATABASE: source database "template1" is being
> accessed by other users"
>
> But I am sure that none of my scripts access 'template1' at that time.
> I have also checked the 'ps -afx' output (logged at the time of failing),
> but no suspects found.
>
> Kindly give me a solution to overcome this problem.
> Also kindly tell me a way to find, which process is accessing the
> template1.
>
>
> Thanks in advance.
>
> regards
> KArthik.S
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>
--
Atte: Dario Brignardello
From | Date | Subject | |
---|---|---|---|
Next Message | Dan The Man | 2005-12-06 19:50:26 | 8.1.0 - PITR - cp: cannot stat |
Previous Message | Bruno Wolff III | 2005-12-06 17:42:28 | Re: ssl and/or md5 encryption |