database instance creation

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/

Thanks.

Thanks,

Prabakaran A

---- On Fri, 18 Feb 2011 12:54:09 +0530 Magnus Hagander &lt;magnus@hagander.net&gt; wrote ----

On Thu, Feb 17, 2011 at 11:35, prabakaran.a &lt;prabakaran.a@zohocorp.com&gt; 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/

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