Обсуждение: 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.
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.
Thanks,
Prabakaran A
![](/media/maillist_attaches/pgsql-general/2011/02/17/12e333082e0.8395659076370914201.-4082304751571677231@zohocorp.com/1279523728575.png)
Prabakaran A
![](/media/maillist_attaches/pgsql-general/2011/02/17/12e333082e0.8395659076370914201.-4082304751571677231@zohocorp.com/1279523728575.png)
Вложения
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.
--
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 ----
Thanks,
Prabakaran A
![](/media/maillist_attaches/pgsql-general/2011/02/18/12e3821db71.8358337859316589909.-6408770770899454368@zohocorp.com/1279523728575.png)
Prabakaran A
![](/media/maillist_attaches/pgsql-general/2011/02/18/12e3821db71.8358337859316589909.-6408770770899454368@zohocorp.com/1279523728575.png)
---- 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/