Re: Backup of database

On 11/26/2013 11:56 AM, Scott Ribe wrote:
> On Nov 26, 2013, at 9:28 AM, joka veera Venkataramana<ramanajvv(at)gmail(dot)com> wrote:
>
>> I know all my questions are basic, why we are asking here is previously we were in DB2 now we moved our database to Postgre (Its new for us). Please help us.
> <http://www.postgresql.org/docs/9.3/interactive/backup.html>
>
> Personally, for daily backups, I like pg_dumpall | bzip2.
If you're using some kind of rsync or rsnapshot to help with backups,
check-out "gzip --rsyncable". It purports to keep the compressed
archive in a better format for rsync-type (changed-block-only)
transfers, at the expense of not using the most advanced algorithm.

I have a script that dumps my db to a local gz file, and alternates
naming it with a .0 or .1 so I always have the last two backups (and
then those backup/archive files are rsync'ed to another machine).

-AJ