From: | Thomas Kellerer <shammat(at)gmx(dot)net> |
---|---|
To: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: Incremental backup |
Date: | 2021-10-29 14:01:42 |
Message-ID: | 218a2d44-b38f-3d90-80d8-ed33d57c156b@gmx.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Peter J. Holzer schrieb am 29.10.2021 um 15:43:
>> Peter, Oracle instance manages collection of the databases and is ensuring
>> recoverabilty using redo logs, which are completely analogous to WAL logs,
>> if managed a bit differently. Let's not be nitpicking here. Oracle instance
>> is completely analogous to Postgres cluster. If you ask me, the word cluster
>> was picked to avoid the word "instance"
>
> I'm quoting Tom Kyte here:
>
> | In fact, it is true to say that an instance will mount and open at
> | most a single database in its entire lifetime!
>
> While that article is originally from 2009, it was last changed in 2021,
> and I'd trust Tom to change something as fundamental if it wasn't true
> anymore.
Well, a single "container database" could contain multiple pluggable databases.
Except for the "pluggable" part, I consider Oracle's pluggable databases quite
similar to Postgres' databases.
From | Date | Subject | |
---|---|---|---|
Next Message | Pratik Mehta | 2021-10-29 14:02:54 | Postgres dblink example |
Previous Message | Ryan Booz | 2021-10-29 13:52:52 | Re: DBeaver does not show all tables in a Schema |