pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Jeff Frost <jeff@pgexperts.com>
To: Denish Patel <denish@omniti.com>
To: Craig James <cjames@emolecules.com>
Cc: Payal Singh <payal@omniti.com>
Cc: pgsql-admin@postgresql.org <pgsql-admin@postgresql.org>
Subject: Re: Cold backup with rsync -- WAL files?
Date: Fri, 06 Dec 2013 13:32:12 -0800
Message-ID: <52A2425C.7020105@pgexperts.com> (raw)
In-Reply-To: <WM!bbb23cd195f9fba80c675c6d28a4232845b3371b3ac485977c1c9d07f3690e9a2a6f634a6ec6c4b51995f6dce806d243!@asav-1.01.com>
References: <CAFwQ8rd+oDkLG4KWkux=2jwNinBnuwhY8DH3W-_58MGO1m3=Lg@mail.gmail.com>
	<23125649.944094.1386343468257.JavaMail.root@mail.int.journyx.com>
	<CAFwQ8rf+-rjYKYZLm=ip+OC2evfSTZwa0hEFi7WOcL6vBYXnAA@mail.gmail.com>
	<CAFwQ8reT_6hEkHaZ36981zA6pS39i+AUePyWsc9aoiX7MH6FeQ@mail.gmail.com>
	<CANUg7LB6yQp4YngQ9zrPHU2OeB5T120Z_hvRoJx9RAvjHbgu8A@mail.gmail.com>
	<CAFwQ8rd9Wo7a6HqviP04dyhr0h9A1Fb-comPkxxzpuoi0NXC_Q@mail.gmail.com>
	<WM!c8658ce9381c4bf437df90c814a1308ff6cbd72c0dc9f8b9ad8b99ac34963b07ad223e770169e65b1a29e90a9f43003c!@asav-1.01.com>
	<B36E5875-ACB1-4FCF-AF5E-10F2C901F77B@pgexperts.com>
	<CAFwQ8rdwE58EVB7Aki0kAdeVELerbh8_oe9GTdP=er1Ku37epg@mail.gmail.com>
	<CAFddxvNy2EQyH3r5kAwabwkghr+sg7oqi+AwRaH93AydDJMeNQ@mail.gmail.com>
	<WM!bbb23cd195f9fba80c675c6d28a4232845b3371b3ac485977c1c9d07f3690e9a2a6f634a6ec6c4b51995f6dce806d243!@asav-1.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

On 12/06/13 13:19, Denish Patel wrote:
> Payal is right. You don't need WAL for Cold backup.

I'm afraid you do.

I just did a test to confirm with 9.2.6:

pg_ctl -D . -m fast stop
rsync . ../data-test -avP
cd ../data-test/pg_xlog
rm -f *
cd ..
pg_ctl -D . start

LOG:  could not open file "pg_xlog/00000001000000020000009B" (log file 2,
segment 155): No such file or directory
LOG:  invalid primary checkpoint record
LOG:  could not open file "pg_xlog/00000001000000020000009B" (log file 2,
segment 155): No such file or directory
LOG:  invalid secondary checkpoint record
PANIC:  could not locate a valid checkpoint record
LOG:  startup process (PID 13141) was terminated by signal 6: Aborted
LOG:  aborting startup due to startup process failure

Then, if I copy the WAL files back from the old stopped data dir:

rsync . ../data/pg_xlog/ pg_xlog/ -avP
pg_ctl -D . start

LOG:  database system was shut down at 2013-12-06 13:25:13 PST
LOG:  database system is ready to accept connections
LOG:  autovacuum launcher started

then it happily starts up.



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



view thread (17+ messages)  latest in thread

Message-ID: <52A2425C.7020105@pgexperts.com>
Permalink:  ../52A2425C.7020105@pgexperts.com/
Also on:    postgresql.org/message-id/52A2425C.7020105@pgexperts.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: jeff@pgexperts.com, denish@omniti.com, cjames@emolecules.com, payal@omniti.com
  Subject: Re: Cold backup with rsync -- WAL files?
  In-Reply-To: <52A2425C.7020105@pgexperts.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