pg.ddx.io pgsql-admin@postgresql.org mailing list archivehelp / color / mirror / Atom feed
From: Merlin Moncure <mmoncure@gmail.com>
To: Michael Nolan <htfoot@gmail.com>
Cc: Richard Broersma <richard.broersma@gmail.com>
Cc: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Cc: pgsql-admin@postgresql.org
Subject: Re: [GENERAL] PITR - base backup question
Date: Wed, 27 Aug 2008 10:18:14 -0400
Message-ID: <b42b73150808270718k10446b95x2782f758cff125f@mail.gmail.com> (raw)
In-Reply-To: <4abad0eb0808270652g3c65caefg2ba065d63830a9d9@mail.gmail.com>
References: <396486430808261553k6687500q19f4117b6c71ae3f@mail.gmail.com>
<b42b73150808261738j605e1bchc1935f81d695fb08@mail.gmail.com>
<396486430808261804l93855f1gf86d92541a80141@mail.gmail.com>
<b42b73150808270512y2867c937h1710512d6010d3c8@mail.gmail.com>
<4abad0eb0808270618w785f34f1pcb2c8d9b062f2d42@mail.gmail.com>
<b42b73150808270632t4823d522i42576a2e8022383c@mail.gmail.com>
<4abad0eb0808270652g3c65caefg2ba065d63830a9d9@mail.gmail.com>
On Wed, Aug 27, 2008 at 9:52 AM, Michael Nolan <htfoot@gmail.com> wrote:
>> This is a nice touch. With a little bash-fu you could do a find |
>> xargs rm and list/kill the files in one pass. In the standby setups
>> I've done I usually script the whole process, a prep on the main and a
>> startup on the standby.
>
> The scripts to create the system level backups and copy them to the backup
> servers and to rsync the WAL files are both cron jobs.
>
> I've considered writing a script to do all the restore tasks on the backup
> server, but I figure if someone other than me ever has to do it, for example
> if there is a problem when I'm unavailable, that person will probably want
> to watch the entire process carefully, since he or she will be far less
> familiar with the configuration.
Here are some basic facts of life about PITR/log shipping. It is a
disaster prevention feature. Here's the scenario:
You are going to depend upon it on 3 a.m. early saturday morning three
years in the future, only you are not going to be there. A drive just
went out on the main, but instead of degrading the entire backplane
went amber. You are going to be in Barbados on your honeymoon, with
no connectivity to the outside world (your blushing bride made you
leave the laptop at home). The guy doing the switchover to the
standby is the only one that could be gotten a hold of, he still
hasn't gotten over the 12 hour bender from Friday. He's never really
understood why your company took your advice and went with PostgreSQL
instead of SQL Server, is cranky, and doesn't like you that much. He
secretly hopes the standby wont come up and barely knows how to use a
console.
write the script.
test it.
merlin
view thread (12+ messages) latest in thread
Message-ID: <b42b73150808270718k10446b95x2782f758cff125f@mail.gmail.com> Permalink: ../b42b73150808270718k10446b95x2782f758cff125f@mail.gmail.com/ Also on: postgresql.org/message-id/b42b73150808270718k10446b95x2782f758cff125f@mail.gmail.com ·
reply
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: mmoncure@gmail.com, htfoot@gmail.com, richard.broersma@gmail.com, pgsql-general@postgresql.org Subject: Re: [GENERAL] PITR - base backup question In-Reply-To: <b42b73150808270718k10446b95x2782f758cff125f@mail.gmail.com> * 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