Thank You All...It Worked
On Tue, Nov 26, 2013 at 1:32 PM, AJ Weber <aweber@xxxxxxxxxxx> wrote:
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.
On 11/26/2013 11:56 AM, Scott Ribe wrote:
On Nov 26, 2013, at 9:28 AM, joka veera Venkataramana<ramanajvv@gmail.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.
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
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
