Re: Incremental backup

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.

In response to

Browse pgsql-general by date

  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