Re: Isolation of multiple databse instances provided by a single postgres server
"Peter J. Holzer" <[email protected]>
| Newsgroups | gmane.comp.db.postgresql.general |
|---|---|
| Message-ID | <[email protected]> |
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.
|_|_) | |
| | | [email protected] | -- Charles Stross, "Creative writing
__/ | http://www.hjp.at/ | challenge!"
signature.asc
(application/pgp-signature, 833 B)
-----BEGIN PGP SIGNATURE----- iQIzBAABCgAdFiEETtJbRjyPwVTYGJ5k8g5IURL+KF0FAl3XDRYACgkQ8g5IURL+ KF3ctw/+MYCVQUVDa2TdRHgsJE200kj/cgpUmp7obypKLToEecdC/RVVM3FfGQH0 dI6FVhcSFPUWeRbSQbFmC/wypBJVu2/hd3eqBJvmnx/DBoEDsgcmZpF+w2/oS4lm qXC/BbyMqUslpdDyenfGb58x8qoUEOu/x3LF8wfODNkrV7RNweIeOMUpSv3Gonm6 3jNZNsXPpzZKYNSrbC9TFmab368Jr63W1AJPjp7yFG+QzEs9biU2Xfn7gKDWgpsN WYlxivBaqPJRwbP4XbY2/aiHXevShP8wDdwQbs/lfAUdxshR9QtpykEFqFpgrHZB oal/NJZyqOK/rvmJRGnBj7yzoJStcpzfJ56nSFP8pLuDNfj/HqVnzqJ7o0dHqFWu S/VbZHFtkz3d2PsAqulNBhD5EdoG2mO/KL0NDsUzKo1c9uG3dS4yrET0lhCpFUQE Y6YoXwDZ1ATHwI2ltrYbQqWq0F6FOD52HaZR6DNKEL0yr+q9s/cNa1RtD8SWRxV7 6lr7ilw5ShaAstPTae5WpeDGbUW01VXgkqXLh3qymSi2rzacpC/FToH//u7PEmZY LEMonDN6Jcveye095YJ87bEROgsMJyegZ+3NWO1rpgO23ko46SojL3sd2plqUi8w FNtyap5D99BXFFNyaUpmTpBKcZUEZgieKph+I2eQUwybCvb7Br8= =fdxp -----END PGP SIGNATURE-----