Re: Isolation of multiple databse instances provided by a singlepostgres server - Mailing list 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@hjp.at         |    -- Charles Stross, "Creative writing
__/   | http://www.hjp.at/ |       challenge!"