Re: Incremental backup

On 10/28/21 11:40 AM, Adrian Klaver wrote:
> On 10/28/21 09:25, Ron wrote:
>> On 10/28/21 10:36 AM, Adrian Klaver wrote:
>>> On 10/28/21 05:23, Edu Gargiulo wrote:
>>>> Hi all,
>>>>
>>>> Is there any way to make incremental backups in postgres-12?
>>>
>>> It would helpful to be more explicit about what you are trying to achieve.
>>>
>>> Do you want:
>>>
>>> 1) A continuous process or scheduled one?
>>>
>>> 2) Local or remote backups?
>>>
>>> 3) The backup as a standby?
>>
>> Standby is not backup!!!!!
>
> But we don't know what the OP is doing so it is best to ask.
>
>> Honestly, these are bizarre questions which no one in the Enterprise
>> world would ask in response to "Is there any way to make incremental
>> backups in Oracle, DB2, SQL Server?" since the answer is a simple "yes,
>> of course" (or maybe "yes, differential backups").
>
> Except we have no way of knowing what the situation is. I prefer not to
> assume a context.

You make it sound like incremental (and differential) backups are some
complicated thing that needs context.  That's utter and complete rubbish in
every Enterprise RDBMS except Postgresql.

Something like "BACKUP DATABASE (DIFFERENTIAL) foo TO foo.bak;" should be a
fundamental feature of every RDBMS that claims to be enterprise class.

--
Angular momentum makes the world go 'round.