Re: Isolation of multiple databse instances provided by a single postgres server

From: "Peter J(dot) Holzer" <hjp-pgsql(at)hjp(dot)at>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Isolation of multiple databse instances provided by a single postgres server
Date: 2019-11-21 22:18:03
Message-ID: 20191121221803.GC17288@hjp.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 2019-11-21 08:18:21 -0600, Ron wrote:
> It appears to me that, within this one Postgres "instance", there are 2
> levels of "isolation", which are database, and schemas. Is this correct?
[...]
> If so, how does this cores pond to physical on disk storage?
>
> It corresponds not at all.

That's not quite true. Each database has a specific directory (per
tablespace) to keep its files in. Schemas on the other hand do not
correspond to anything on the filesystem.

hp

--
_ | Peter J. Holzer | Story must make more sense than reality.
|_|_) | |
| | | hjp(at)hjp(dot)at | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2019-11-21 22:21:32 Re: Isolation of multiple databse instances provided by a single postgres server
Previous Message Adrian Klaver 2019-11-21 22:11:08 Re: Help with authentication on Debain/Ubuntu installation