| From: | hvjunk <hvjunk(at)gmail(dot)com> |
|---|---|
| To: | Hannes Erven <hannes(at)erven(dot)at> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: postgres large database backup |
| Date: | 2022-12-06 04:44:15 |
| Message-ID: | 52B3F216-2F91-4442-B6CA-7EE6FE960351@gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
> On 01 Dec 2022, at 01:19, Hannes Erven <hannes(at)erven(dot)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-demand throw-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 goot single snapshot backup solution.
My cases doesn't need the PITR yet
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Pavel Stehule | 2022-12-06 10:47:07 | Re: plpgsql_check_function issue after upgrade |
| Previous Message | Alexis Zapata | 2022-12-06 03:01:57 | Solved: Table : Bloat grow high |