Re: Incremental backup - Mailing list pgsql-general

From Thomas Kellerer
Subject Re: Incremental backup
Date
Msg-id 218a2d44-b38f-3d90-80d8-ed33d57c156b@gmx.net
Whole thread Raw
In response to Re: Incremental backup  ("Peter J. Holzer" <hjp-pgsql@hjp.at>)
List 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.





pgsql-general by date:

Previous
From: Ryan Booz
Date:
Subject: Re: DBeaver does not show all tables in a Schema
Next
From: Pratik Mehta
Date:
Subject: Postgres dblink example