Thread: Starting and stopping database by JAVA

Starting and stopping database by JAVA

From
juleni@livetrade.cz
Date:
Hello,

   is there a possibility starting or stopping postgres database and
creating database instance by JAVA? Is there some API available for
this? If yes, can you please write some example, how to do it?

   Thank you in advance,

   with best regards,

   Julian Legeny

 mailto:juleni@livetrade.cz


Re: Starting and stopping database by JAVA

From
Richard Huxton
Date:
juleni@livetrade.cz wrote:
> Hello,
>
>    is there a possibility starting or stopping postgres database and
> creating database instance by JAVA? Is there some API available for
> this? If yes, can you please write some example, how to do it?

Starting/stopping a system service is by its nature going to be
operating-system specific, so I think you're best bet would be to call
some external scripts to do this.

Creating a new database can be done by connecting to database template1
and issuing "CREATE DATABASE ...", you can do similarly with users. See
the "SQL Commands" section of the manuals for details.

HTH
--
   Richard Huxton
   Archonet Ltd