Thread: database instance creation

Dear All,

 In Mysql, If we create a directory under mysql/data, mysql treated as database instance without starting mysql server.
 Is there any similar provision in postgres where we can create a database instance without starting postgresql server.

No, unfortunately there isn't (that would never work, but in theory we could have some attach/detatch command that would do it but there is no such thing). You can do a dump/reload of a single database, but that's the only thing...


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/

prabakaran.a@zohocorp.com ("prabakaran.a") writes:
> Dear All,
>
>  In Mysql, If we create a directory under mysql/data, mysql treated as
> database instance without starting mysql server.
>  Is there any similar provision in postgres where we can create a
> database instance without starting postgresql server.

Well, the Postgres program initdb is used to create a database instance;
it does not automatically start a server against it.  That sounds like
that might be a similar provision.
--
"Programming today  is a race  between software engineers  striving to
build bigger and better  idiot-proof programs, and the Universe trying
to  produce  bigger  and  better  idiots.  So  far,  the  Universe  is
winning."  -- Rich Cook

Thanks.



---- On Fri, 18 Feb 2011 12:54:09 +0530 Magnus Hagander <magnus@hagander.net> wrote ----

On Thu, Feb 17, 2011 at 11:35, prabakaran.a <prabakaran.a@zohocorp.com> wrote:

Dear All,

 In Mysql, If we create a directory under mysql/data, mysql treated as database instance without starting mysql server.
 Is there any similar provision in postgres where we can create a database instance without starting postgresql server.

No, unfortunately there isn't (that would never work, but in theory we could have some attach/detatch command that would do it but there is no such thing). You can do a dump/reload of a single database, but that's the only thing...


--
 Magnus Hagander
 Me: http://www.hagander.net/
 Work: http://www.redpill-linpro.com/