From: AJ Weber <aweber@comcast.net>
To: pgsql-admin@postgresql.org
Subject: Re: Backup of database
Date: Tue, 26 Nov 2013 13:32:55 -0500
Message-ID: <5294E957.1000802@comcast.net> (raw)
In-Reply-To: <B00D83F7-38D0-4643-BE17-C8F8AB1DDB10@elevated-dev.com>
References: <CANGhxCgYrQbvegp1MbjbQ0SLpoVOC1TSqZYBObgE9pO4_N+Dbw@mail.gmail.com>
<B00D83F7-38D0-4643-BE17-C8F8AB1DDB10@elevated-dev.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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.
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
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: aweber@comcast.net
Subject: Re: Backup of database
In-Reply-To: <5294E957.1000802@comcast.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox