Re: Concrete steps for use of PITR warm backup?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On Thu, Jun 13, 2013 at 10:51 AM, francis picabia <fpicabia@xxxxxxxxx> wrote:
> 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?

I still think the documentation is lacking real life examples, but my
needs have been met by pgbarman.  It is very good, saves developing
a script yourself, and works at 4 AM when your brain is not.  I also
like that barman is so easy that I can go on vacation and anyone
can follow the instructions for recovery.


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




[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux