But even that alternate template database would need to be created the
first time after server installation by connceting to the template1 DB??
Right??
All I want is to automate database creation the first time after server
installation eliminate user inputs
-----Original Message-----
From: Kris Jurka [mailto:books@ejurka.com]
Sent: Monday, July 04, 2005 3:01 PM
To: Nidhi Srivastava
Cc: Thomas Dudziak; pgsql-jdbc@postgresql.org; John R Pierce
Subject: Re: [JDBC] Create Database using JDBC
On Mon, 4 Jul 2005, Nidhi Srivastava wrote:
> Even when I'm not accessing templte1 but any other scratch database
> through pgAdmin and try to create a new DB using JDBC I get the same
> ERROR: CREATE DATABASE: source database "template1" is being accessed
> by other users. Is there a way to check if a DB exists and create it
if
> it doesn't using JDBC. How can I ensure that pgAdmin is not open on
any
> of the client machines and connected to the Postgre server on my
> machine....becuase if even a single pgAdmin client is open on any of
the
> client machines it doesn't allow me to create a new DB throwing the
> above error.
>
I would suggest using an alernate template database to create new
databases with. You could even mark it to refuse connections to ensure
no
one else will connect to it and block your operation.
Kris Jurka