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>
Cc: 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:56:09 -0800
Message-ID: <52A247F9.9060703@pgexperts.com> (raw)
In-Reply-To: <WM!9ac049737244dd14be8b909c72fdce8b51bba56dccef3aba43666f54a16a01a91105190bad581de7284175e8cf9f431d!@asav-1.01.com>
References: <CAFwQ8rd+oDkLG4KWkux=2jwNinBnuwhY8DH3W-_58MGO1m3=Lg@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>
	<52A2425C.7020105@pgexperts.com>
	<CAFddxvOPbLKaHyhAcOGihq_rk5XcTbZW9dyX76_S5mTqvWP0XA@mail.gmail.com>
	<WM!9ac049737244dd14be8b909c72fdce8b51bba56dccef3aba43666f54a16a01a91105190bad581de7284175e8cf9f431d!@asav-1.01.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>

On 12/06/13 13:40, Denish Patel wrote:
> Jeff,
>
> If you remove pg_xlogs,  I do not expect Postgres to come back! 
>
> I think Craig is referring to WAL files , not pg_xlogs. He is still going to
> take backup of pg_xlogs under $PGDATA when Postgres is still down. 
>
> I think there is some misunderstanding here!
>

I think the misunderstanding might be that you mean *archived* WAL files, and
I mean WAL files in the PGDATA directory.
I think the latter is what the OP means, but I'm not certain.

So, no, you do not need archiving enabled to take a cold backup, but you do
need all the WAL files from the pg_xlog directory per mine and Kevin's quick test.


-- 
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: <52A247F9.9060703@pgexperts.com>
Permalink:  ../52A247F9.9060703@pgexperts.com/
Also on:    postgresql.org/message-id/52A247F9.9060703@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: <52A247F9.9060703@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