Re: Reliably backing up a live database

From: Tanstaafl <tanstaafl(at)libertytrek(dot)org>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Reliably backing up a live database
Date: 2013-12-31 15:19:28
Message-ID: 52C2E080.8040104@libertytrek.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

On 2013-12-31 10:16 AM, Ken Benson <ken(at)infowerks(dot)com> wrote:
> On 12/31/2013 5:40 AM, Tanstaafl wrote:
>> So, is it possible to get a gzipped (or otherwise compressed) dump
>> using pg_dumpall?

> I believe you have to use
> pg_dumpall --username=username -o | gzip > mydb_backup.sql.gz

Thanks Ken, googling revealed this solution and I was just getting ready
to reply if this was the only/best way...

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Magnus Persson 2013-12-31 16:14:11 Passing result of multirow subquery to C function
Previous Message Ken Benson 2013-12-31 15:16:19 Re: Reliably backing up a live database