Received: from malur.postgresql.org ([217.196.149.56])
	by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40858=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UOWFw-0002uu-Bf
	for pgsql-admin@arkaria.postgresql.org; Sat, 06 Apr 2013 16:46:20 +0000
Received: from localhost ([127.0.0.1] helo=postgresql.org)
	by malur.postgresql.org with smtp (Exim 4.72) (envelope-from
	<pgsql-admin-owner+M40858=pgsql+2Dadmin=arkaria.postgresql.org@postgresql.org>)
	id 1UOWFv-0002Sw-Mu
	for pgsql-admin@arkaria.postgresql.org; Sat, 06 Apr 2013 16:46:19 +0000
Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jim@reptiles.org>) id 1UOWFv-0002Sr-3U
	for pgsql-admin@postgresql.org; Sat, 06 Apr 2013 16:46:19 +0000
Received: from mail2.reptiles.org ([198.96.210.226])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <jim@reptiles.org>) id 1UOWFj-0003qe-5S
	for pgsql-admin@postgresql.org; Sat, 06 Apr 2013 16:46:18 +0000
Received: from localhost by mailbox.reptiles.org
	via sendmail with STDIO (1164 bytes) (sender: <jim@reptiles.org>)
	(ident <jim> using UNIX) id <m1UOWFh-000t9cC@mailbox.reptiles.org>
	for <pgsql-admin@postgresql.org>;
	Sat, 6 Apr 2013 12:46:05 -0400 (EDT)
	(Smail-3.2.0.121 2005-Nov-17 #10 built 2010-Jul-16)
Date: Sat, 6 Apr 2013 12:46:05 -0400
From: Jim Mercer <jim@reptiles.org>
To: pgsql-admin@postgresql.org
Subject: purpose/use of pg_start_backup() pg_stop_backup()
Message-ID: <20130406164605.GV24874@reptiles.org>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.5.20 (2009-06-14)
X-Pg-Spam-Score: -4.3 (----)
List-Archive: <http://archives.postgresql.org/pgsql-admin>
List-Help: <mailto:majordomo@postgresql.org?body=help>
List-ID: <pgsql-admin.postgresql.org>
List-Owner: <mailto:pgsql-admin-owner@postgresql.org>
List-Post: <mailto:pgsql-admin@postgresql.org>
List-Subscribe: <mailto:majordomo@postgresql.org?body=sub%20pgsql-admin>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
X-Mailing-List: pgsql-admin
Precedence: bulk
Sender: pgsql-admin-owner@postgresql.org


on the surface, the functions pg_start_backup() and pg_stop_backup() seem to
indicate something very useful.

as i understand it, i could do:

psql -c "pg_start_backup('$(date +%Y%m%d%H%M%S)');"
snapshot/dump $PGDATA
psql -c "pg_stop_backup();"

and this would then create a nice clean snapshot.

however, i'm trying to work out what the restore process is.

its not clear to me if one needs to do anything after restoring the dump.

or, if there is some sort of incremental process that needs to be followed
after the dump.

can someone provide a walk-through of using these functions both for 
a backup and a restore?

-- 
Jim Mercer     Reptilian Research      jim@reptiles.org    +1 416 410-5633
"He who dies with the most toys is nonetheless dead"


-- 
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin