Re: How can I have 2 completely seperated databases in

Hello,

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

hong(dot)ge(at)yale(dot)edu 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 <pg(at)rbt(dot)ca>:
>
>
>>On Wed, 2004-02-11 at 16:36, hong(dot)ge(at)yale(dot)edu 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 majordomo(at)postgresql(dot)org)