pg.ddx.io pgsql-admin@postgresql.org mailing list archive
help / color / mirror / Atom feedCreating multiple database at runtime in postgresql
4+ messages / 3 participants
[nested] [flat]
* Creating multiple database at runtime in postgresql
@ 2010-12-02 09:35 Manasi Save <manasi.save@artificialmachines.com>
0 siblings, 1 reply; 4+ messages in thread
From: Manasi Save @ 2010-12-02 09:35 UTC (permalink / raw)
To: pgsql-admin
Dear All,
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, 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 account 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.
As whenever I create a database in MySQL it gets stored on my hard disk these are file level operations if we use mysql MyIsAM storage engine.
Is it possible to create postgresql database using postgresql stored functions/
Is it possible to have 1000,000 databases on a server?
Please let me know if anyone needs more information on what I am trying to implement.
Any input will be a great help.
Regards,
Manasi
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Creating multiple database at runtime in postgresql
@ 2010-12-02 14:11 Julio Leyva <jcleyva@hotmail.com>
parent: Manasi Save <manasi.save@artificialmachines.com>
0 siblings, 0 replies; 4+ messages in thread
From: Julio Leyva @ 2010-12-02 14:11 UTC (permalink / raw)
To: manasi.save@artificialmachines.com; pgsql-admin
Probably what you need is to have a different schemes instead
From: manasi.save@artificialmachines.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Creating multiple database at runtime in postgresql
Date: Thu, 2 Dec 2010 04:35:25 -0500
Dear All,
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, 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 account
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.
As whenever I create a database in MySQL it gets stored on my hard disk these
are file level operations if we use mysql MyIsAM storage engine.
Is it possible to create postgresql database using postgresql stored
functions/
Is it possible to have 1000,000 databases on a server?
Please let me know if anyone needs more information on what I am trying to
implement.
Any input will be a great help.
Regards,
Manasi
=
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Creating multiple database at runtime in postgresql
@ 2010-12-03 06:22 Manasi Save <manasi.save@artificialmachines.com>
0 siblings, 1 reply; 4+ messages in thread
From: Manasi Save @ 2010-12-03 06:22 UTC (permalink / raw)
To: pgsql-admin@postgresql.org, Julio Leyva <jcleyva@hotmail.com>
Thank you Julio.
Could you provide me any reference link for understanding how to use
postgresql schema?
Regards,
Manasi
On Thu, 2 Dec 2010 14:11:40 +0000, Julio Leyva wrote:
Probably what you need is to have a different schemes instead
-------------------------
From: manasi.save@artificialmachines.com
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Creating multiple database at runtime in postgresql
Date: Thu, 2 Dec 2010 04:35:25 -0500
Dear All,
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, 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 account 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.
As whenever I create a database in MySQL it gets stored on my hard
disk these are file level operations if we use mysql MyIsAM storage
engine.
Is it possible to create postgresql database using postgresql stored
functions/
Is it possible to have 1000,000 databases on a server?
Please let me know if anyone needs more information on what I am
trying to implement.
Any input will be a great help.
Regards,
Manasi
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Creating multiple database at runtime in postgresql
@ 2010-12-03 07:19 Scott Marlowe <scott.marlowe@gmail.com>
parent: Manasi Save <manasi.save@artificialmachines.com>
0 siblings, 0 replies; 4+ messages in thread
From: Scott Marlowe @ 2010-12-03 07:19 UTC (permalink / raw)
To: Manasi Save <manasi.save@artificialmachines.com>; +Cc: pgsql-admin@postgresql.org, Julio Leyva <jcleyva@hotmail.com>
On Thu, Dec 2, 2010 at 11:22 PM, Manasi Save
<manasi.save@artificialmachines.com> wrote:
>
> Thank you Julio.
>
> Could you provide me any reference link for understanding how to use
> postgresql schema?
http://www.postgresql.org/docs/8.4/static/ddl-schemas.html
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2010-12-03 07:19 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2010-12-02 09:35 Creating multiple database at runtime in postgresql Manasi Save <manasi.save@artificialmachines.com>
2010-12-02 14:11 ` Julio Leyva <jcleyva@hotmail.com>
2010-12-03 06:22 Re: Creating multiple database at runtime in postgresql Manasi Save <manasi.save@artificialmachines.com>
2010-12-03 07:19 ` Scott Marlowe <scott.marlowe@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox