Re: postgres large database backup - Mailing list pgsql-general

From hvjunk
Subject Re: postgres large database backup
Date
Msg-id 52B3F216-2F91-4442-B6CA-7EE6FE960351@gmail.com
Whole thread Raw
In response to Re: postgres large database backup  (Hannes Erven <hannes@erven.at>)
List pgsql-general
> On 01 Dec 2022, at 01:19, Hannes Erven <hannes@erven.at> wrote:
>
> You could also use a filesystem that can do atomic snapshots - like ZFS.
>
> However, I'm wondering why none of the previous respondents mentioned it?

the reason: 'cause most people are "stuck" on public clouds that does not provide that as a "solution" in their cookie
cutter(wrongly called "managed") solutions... 

> Sure, ZFS may have its own performance implications... but my experience is that it makes "safety snapshots" and
"on-demandthrow-away testing environments" very convenient to use. 

Using that myself, but also as a VM in a ProxMox environmenet, I've found (and restored) with ProxMox Backup Server
gootsingle snapshot backup solution. 

My cases doesn't need the PITR yet


pgsql-general by date:

Previous
From: Alexis Zapata
Date:
Subject: Solved: Table : Bloat grow high
Next
From: Pavel Stehule
Date:
Subject: Re: plpgsql_check_function issue after upgrade