From: Jim Mercer <jim@reptiles.org>
To: pgsql-admin@postgresql.org
Subject: purpose/use of pg_start_backup() pg_stop_backup()
Date: Sat, 6 Apr 2013 12:46:05 -0400
Message-ID: <20130406164605.GV24874@reptiles.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
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
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: jim@reptiles.org
Subject: Re: purpose/use of pg_start_backup() pg_stop_backup()
In-Reply-To: <20130406164605.GV24874@reptiles.org>
* 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