Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 692BB65039C; Tue, 26 Aug 2008 21:46:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 45118-03-3; Tue, 26 Aug 2008 21:45:53 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from outbound.icp-qv1-irony-out3.iinet.net.au (outbound.icp-qv1-irony-out3.iinet.net.au [203.59.1.148]) by postgresql.org (Postfix) with ESMTP id 236EF6503BE; Tue, 26 Aug 2008 21:19:46 -0300 (ADT) X-IronPort-Anti-Spam-Filtered: true X-IronPort-Anti-Spam-Result: AvAFANw5tEjL1iYg/2dsb2JhbACIAINjhT6pHIFr X-IronPort-AV: E=Sophos;i="4.32,274,1217779200"; d="scan'208";a="306757623" Received: from unknown (HELO mail.outtalimits.com.au) ([203.214.38.32]) by outbound.icp-qv1-irony-out3.iinet.net.au with ESMTP; 27 Aug 2008 08:19:42 +0800 Received: from www.outtalimits.com.au (localhost [127.0.0.1]) by mail.outtalimits.com.au (Postfix) with ESMTP id 2033B2B6405C; Wed, 27 Aug 2008 10:19:42 +1000 (EST) MIME-Version: 1.0 Date: Wed, 27 Aug 2008 10:19:42 +1000 From: To: Richard Broersma Cc: pgsql-general@postgresql.org, pgsql-admin@postgresql.org Subject: Re: PITR - base backup question In-Reply-To: <396486430808261553k6687500q19f4117b6c71ae3f@mail.gmail.com> References: <396486430808261553k6687500q19f4117b6c71ae3f@mail.gmail.com> Message-ID: X-Sender: steve@outtalimits.com.au User-Agent: RoundCube Webmail/0.2a Content-Type: text/plain; charset="UTF-8" Content-Transfer-Encoding: 8bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200808/184 X-Sequence-Number: 30029 Hi Richard, This means a file systems backup. eg. tar -cvpf data_bakup.tar /var/lib/pgsql/data Here's a script I use to automate this process. It may be helpful to customize for yourself. #!/bin/bash # # PostgreSQL Weekly Backup # DATE=$(date +%G%m%d) MAILLOG="/backup/weekly_$DATE.log" WALARCH="/pgbackup" DESTINATION="X.X.X.X::rsyncshare/" EMAILDEST="" touch $MAILLOG echo -e "::::::::::::::: $DATE Pallas1 Weekly WAL Backup :::::::::::::::" >> $MAILLOG psql -U postgres -c "select pg_start_backup ('$DATE');" cd /var/lib/pgsql tar -cvpzf "pgbackup_$DATE.tar.gz" data/ >> $MAILLOG 2>&1 psql -U postgres -c "select pg_stop_backup ();" find $WALARCH -perm 600 -mmin "+360" -exec rm {} \; >> $MAILLOG 2>&1 find $WALARCH/data_dir_backup -mtime "+5" -exec rm {} \; >> $MAILLOG 2>&1 ls -la $WALARCH >> $MAILLOG 2>&1 mv /var/lib/pgsql/pgbackup_$DATE.tar.gz /$WALARCH/data_dir_backup/. rsync -a -v -v --progress --stats --delete "/$WALARCH" $DESTINATION >> $MAILLOG 2>&1 /bin/cat $MAILLOG | mail -s "Weekly WAL Backup - Successful" $EMAILDEST && rm $MAILLOG On Tue, 26 Aug 2008 15:53:33 -0700, "Richard Broersma" wrote: > From the following link: > http://www.postgresql.org/docs/8.3/interactive/continuous-archiving.html#BACKUP-BASE-BACKUP > > Step 3 says to perform the back up. > > Does this mean a File System Backup of the Data directory? > OR > Does this mean performing a pg_dumpall and backing up the dump file? > > -- > Regards, > Richard Broersma Jr. > > Visit the Los Angeles PostgreSQL Users Group (LAPUG) > http://pugs.postgresql.org/lapug > >