Re: Reliably backing up a live database - Mailing list pgsql-novice

From Tanstaafl
Subject Re: Reliably backing up a live database
Date
Msg-id 52C2E080.8040104@libertytrek.org
Whole thread Raw
In response to Re: Reliably backing up a live database  (Ken Benson <ken@infowerks.com>)
List pgsql-novice
On 2013-12-31 10:16 AM, Ken Benson <ken@infowerks.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...


pgsql-novice by date:

Previous
From: Ken Benson
Date:
Subject: Re: Reliably backing up a live database
Next
From: Magnus Persson
Date:
Subject: Passing result of multirow subquery to C function