I think my needs are standard for PITR: single master server and single backup server, warm, with desire for PITR. I'm running postgres 8.4. I've looked at Postgres docs on warm backup, and several blogs attempting instructions to help. Everything I've seen does a good job of documenting the initial set up: - how to backup the postgres instance using rsync to second server - how to enable wal archiving with rsync to second server After that, the instructions are less clear. I've also checked out barman. It also is good at describing the initial set up, but when it is time to describe PITR use, they defer to Postgres docs and training which they sell. Is there a good guide with examples on how to configure and *use* a PITR solution? I'm having problems with finding examples discussing: - how to start up backup postgres and incorporate wal files - how to maintain the build up of wal files (with explicit example) - whether to run (or not run) the backup postgres service I've made attempts to set up the backup, with failure. It seems we need the WAL files in the pg_xlog directory, but postgres refuses to start. It isn't surprising to me as I had to try rather than know. Postgres documentation is written with too many statements along the "If... Then..." format. When you already know what to do, this format is sufficient. When you are looking for a set of steps, even an example scenario, this is insufficient. I'd think the scenario of single master, single backup, PITR with warm recovery from WAL archive, is very typical and what many people are looking for. Can't it be documented clearly with a complete set of steps? -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin
