Re: Incremental backup with RSYNC or something? - Mailing list pgsql-general

From Robins Tharakan
Subject Re: Incremental backup with RSYNC or something?
Date
Msg-id 4EBFC8D3.7040302@comodo.com
Whole thread Raw
In response to Re: Incremental backup with RSYNC or something?  (Robins Tharakan <robins.tharakan@comodo.com>)
Responses Re: Incremental backup with RSYNC or something?  (Gregg Jaskiewicz <gryzman@gmail.com>)
List pgsql-general
> You could also do a
>
> pg_dump -Fc | gzip -1 -c > dumpfile.gz
>
> at the cost of a slightly larger (but faster backup).

Actually if you're going this route, you could skip even the pg_dump
compression as well...

pg_dump db | gzip -1 -c > dumpfile.gz

--
Robins Tharakan

pgsql-general by date:

Previous
From: Robins Tharakan
Date:
Subject: Re: Incremental backup with RSYNC or something?
Next
From: alextc
Date:
Subject: Re: Error with Application Stack Builder 3.0.0