On Wed, Oct 12, 2011 at 12:48:45PM -0700, rbastedo wrote:
> I've recently been given the task of setting up BackupPC to back up
> some of our servers running RHEL and PgSQL.
> Management wants me to back up data to an NFS where it can then be
> saved to tape via DPM for offsite storage.
> 
> I have set up a pair of test machines, the BackupPC server is on a
> RHEL 6 box and the target I am backing up is a little CentOS 5 desktop.
> BackupPC is successfully backing up the CentOS machine to it's
>/data/BackupPC TopDir. I've used rsync with ssh2 to perform 2 small backups.

How are you backing up postgres?

 Are you dumping the database (pg_dumpall) and then backing up the
   resulting file with backupc?
 Are you shutting down postgres before doing the backups of the
     data area using backuppc and then restarting after the backup
     is complete?
 Do you have backuppc customized to perform a PITR backup?

If you aren't doing one of these three things your postgres backups
are pretty much worthless and won't be able to be restored.

Given this is your first foray into backups I thought these may be
important things to check.

-- 
                                -- rouilj

John Rouillard       System Administrator
Renesys Corporation  603-244-9084 (cell)  603-643-9300 x 111

------------------------------------------------------------------------------
The demand for IT networking professionals continues to grow, and the
demand for specialized networking skills is growing even more rapidly.
Take a complimentary Learning@Ciosco Self-Assessment and learn 
about Cisco certifications, training, and career opportunities. 
http://p.sf.net/sfu/cisco-dev2dev
_______________________________________________
BackupPC-users mailing list
BackupPC-users AT lists.sourceforge DOT net
List:    https://lists.sourceforge.net/lists/listinfo/backuppc-users
Wiki:    http://backuppc.wiki.sourceforge.net
Project: http://backuppc.sourceforge.net/