Hi Laurenz,
Il 01/12/12 12:18, Albe Laurenz ha scritto:
Gabriele, I understand that you want to spread the word,
but the OP's problem was a different one:
You are right. I totally missed that. I skimmed the email (very quickly)
and thought that in that particular context Andrew was referring to PITR
in general.
He wants to create a base backup by just copying the
data directory of an 8.4 warm standby server.
There is no possibility to run pg_(start|stop)_backup,
but the documentation seems to suggest that it could work
anyway:
http://www.postgresql.org/docs/8.4/static/warm-standby.html#BACKUP-INCREMENTAL-UPDATED
Yes, it is possible. I'd like to try and implement that in Barman, in
order to automate this. I'd try and follow this path though:
pg_start_backup() on the master, wait for the operation to be replayed
on the standby (with pg_controldata if < 9.0 or through hot standby),
rsync/tar from the standby, then pg_stop_backup() on the master. If you
think of following this path yourself, please make sure you test it
accurately (especially for production environment).
Sorry Andrew about misunderstanding the original question.
Cheers,
Gabriele
--
Gabriele Bartolini - 2ndQuadrant Italia
PostgreSQL Training, Services and Support
gabriele.bartolini@xxxxxxxxxxxxxx | www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
