Depending on your needs and transaction load per database you can easily run 30 databases on a machine with 2 Gig of RAM. You will of course have to use initdb for each cluster and change the tcp port for each cluster but it works just fine.
Sincerely,
Joshua D. Drake
[EMAIL PROTECTED] wrote:
Thank you very much for your reply.
Yes, that's true. But it seems not a good idea if I have many databases and I want them totally seperated with each other.
What's your opinion? Thanks.
--Hong Ge
Quoting Rod Taylor <[EMAIL PROTECTED]>:
On Wed, 2004-02-11 at 16:36, [EMAIL PROTECTED] wrote:
Hi, all
What should I do if I want to have 2 completely seperated databases
in
PostgreSQL? I want each database to have its own data, log and everything needed to access that database. I don't want them to
share
anything. Has anyone done this before? Or, could anyone give me some clue of how to do this?
You will need to initdb 2 locations and start 2 instances on separate ports.
---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])
begin:vcard fn:Joshua Drake n:Drake;Joshua org:Command Prompt, Inc. adr:;;P.O. Box 215;Cascade Locks;OR;97014;US email;internet:[EMAIL PROTECTED] title:Consultant tel;work:503-667-4564 tel;fax:503-210-0334 note:Home of Mammoth PostgreSQL, and PostgreSQL Replicator. x-mozilla-html:FALSE url:http://www.commandprompt.com/ version:2.1 end:vcard
---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend
