Re: database instance creation - Mailing list pgsql-general

From Magnus Hagander
Subject Re: database instance creation
Date
Msg-id AANLkTimO9AS7ckv_WJ5LhS-2UerU0Z7b-KrsUkxsCnoA@mail.gmail.com
Whole thread Raw
In response to database instance creation  ("prabakaran.a" <prabakaran.a@zohocorp.com>)
Responses Re: database instance creation
List pgsql-general

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/

pgsql-general by date:

Previous
From: Mike Christensen
Date:
Subject: Any feedback on this query?
Next
From: Alban Hertroys
Date:
Subject: Re: PostgresPlus Windows Installation Error