Re: How can I have 2 completely seperated databases in PostgreSQL?

From: hong(dot)ge(at)yale(dot)edu
To: Rod Taylor <pg(at)rbt(dot)ca>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: How can I have 2 completely seperated databases in PostgreSQL?
Date: 2004-02-11 22:51:54
Message-ID: 1076539914.402ab20a38346@www.mail.yale.edu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

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.
>

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Matthew T. O'Connor 2004-02-11 22:57:19 Re: [BUGS] Bug in pg_autovacuum ?
Previous Message hong.ge 2004-02-11 22:48:51 Re: How can I have 2 completely seperated databases in PostgreSQL?