Received: from maia.hub.org (maia-5.hub.org [200.46.204.29]) by mail.postgresql.org (Postfix) with ESMTP id 9CEAA1337B49 for ; Thu, 2 Dec 2010 10:11:49 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.29]) (amavisd-maia, port 10024) with ESMTP id 47150-03 for ; Thu, 2 Dec 2010 14:11:43 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6 Received: from bay0-omc1-s28.bay0.hotmail.com (bay0-omc1-s28.bay0.hotmail.com [65.54.190.39]) by mail.postgresql.org (Postfix) with ESMTP id 328BF1337B47 for ; Thu, 2 Dec 2010 10:11:41 -0400 (AST) Received: from BAY154-W59 ([65.54.190.61]) by bay0-omc1-s28.bay0.hotmail.com with Microsoft SMTPSVC(6.0.3790.4675); Thu, 2 Dec 2010 06:11:40 -0800 Message-ID: Content-Type: multipart/alternative; boundary="_28b8889b-b1bb-4b31-9121-077cba7e6ecb_" X-Originating-IP: [207.164.182.8] From: Julio Leyva To: , Subject: Re: Creating multiple database at runtime in postgresql Date: Thu, 2 Dec 2010 14:11:40 +0000 Importance: Normal In-Reply-To: <20101202043525.hgmxqp7vca4okksw@mail.artificialmachines.com> References: <20101202043525.hgmxqp7vca4okksw@mail.artificialmachines.com> MIME-Version: 1.0 X-OriginalArrivalTime: 02 Dec 2010 14:11:40.0884 (UTC) FILETIME=[D7505940:01CB922A] X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-1.907 tagged_above=-10 required=5 tests=BAYES_00=-1.9, FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001, RCVD_IN_DNSWL_NONE=-0.0001, RFC_ABUSE_POST=0.001, T_RP_MATCHES_RCVD=-0.01 X-Spam-Level: X-Archive-Number: 201012/19 X-Sequence-Number: 36248 --_28b8889b-b1bb-4b31-9121-077cba7e6ecb_ Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Probably what you need is to have a different schemes instead=20 =20 From: manasi.save@artificialmachines.com To: pgsql-admin@postgresql.org Subject: [ADMIN] Creating multiple database at runtime in postgresql Date: Thu=2C 2 Dec 2010 04:35:25 -0500 Dear All=2C =20 I am new to postgresql database. I want to create an architecture wherein I= want to create multiple databases at runtime. To be more description about the purpose=2C for example I am creating an account using any application which has postgresql as a backend. I want to create a new database for every user who is creating acc= ount then whenever the user login he will be login to his database. I have such = kind of setup in MySQL but I would really like to know is it a good idea to have= such kind of setup and is it possible in postgresql.=20 =20 As whenever I create a database in MySQL it gets stored on my hard disk the= se are file level operations if we use mysql MyIsAM storage engine. =20 Is it possible to create postgresql database using postgresql stored functions/ Is it possible to have 1000=2C000 databases on a server? =20 Please let me know if anyone needs more information on what I am trying to implement. =20 Any input will be a great help.=20 =20 Regards=2C Manasi=20 = --_28b8889b-b1bb-4b31-9121-077cba7e6ecb_ Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Probably what you need is to have a different schemes instead
 =3B =

From: manasi.save@artificialmachines.com
To:= pgsql-admin@postgresql.org
Subject: [ADMIN] Creating multiple database = at runtime in postgresql
Date: Thu=2C 2 Dec 2010 04:35:25 -0500

D= ear All=2C
 =3B
I am new to postgresql database. I want to create an architecture wherein I= want to create multiple databases at runtime. To be more description about the purpose=2C for example
I am creating an account using any application which has postgresql as a backend. I want to create a new database for every user who is creating acc= ount then whenever the user login he will be login to his database. I have such = kind of setup in MySQL but I would really like to know is it a good idea to have= such kind of setup and is it possible in postgresql. =3B
 =3B
As whenever I create a database in MySQL it gets stored on my hard disk the= se are file level operations if we use mysql MyIsAM storage engine.
 =3B
Is it possible to create postgresql database using postgresql stored functions/
Is it possible to have 1000=2C000 databases on a server?
 =3B
Please let me know if anyone needs more information on what I am trying to implement.
 =3B
Any input will be a great help. =3B
 =3B
Regards=2C
Manasi =3B
= --_28b8889b-b1bb-4b31-9121-077cba7e6ecb_--