Re: Backup

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: "pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Backup
Date: 2024-10-16 20:00:30
Message-ID: CANzqJaA_bNat1U3Ku4PARtDw99zvYaA-ERTEdK7TKTaJkDsJtA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Wed, Oct 16, 2024 at 3:52 PM Tomas Vondra <tomas(at)vondra(dot)me> wrote:
[snip]

> You didn't specify the Postgres version - that matters, because older
> pg_dump versions (before PG 16) do not support compression. Since PG 16
> you can use either -Fc or -Fd (instead of the tar format), and it'll
> compress the output using gzip.
>

Not true. pg_dump has had built-in gzipping of directory format backups
since at least 9.6. Probably earlier.
--
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> crustacean!

In response to

  • Re: Backup at 2024-10-16 19:52:44 from Tomas Vondra

Browse pgsql-general by date

  From Date Subject
Next Message Ron Johnson 2024-10-16 20:02:24 Re: Backup
Previous Message Achilleas Mantzios 2024-10-16 19:59:47 Re: Backup