Re: Backup of shut down standby does not work?

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Jürgen Fuchsberger <juergen(dot)fuchsberger(at)uni-graz(dot)at>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Backup of shut down standby does not work?
Date: 2014-02-13 14:01:08
Message-ID: EFC0F9A0-6115-45EF-9752-E24511EC7DEC@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Feb 13, 2014, at 1:37 AM, Jürgen Fuchsberger <juergen(dot)fuchsberger(at)uni-graz(dot)at> wrote:

> So am I doing something wrong or are the WAL files really needed?

If you're backing up a live server, and there is activity during the backup...

You're missing step 1.5: select pg_start_backup('whatever') on the server.

--
Scott Ribe
scott_ribe(at)elevated-dev(dot)com
http://www.elevated-dev.com/
(303) 722-0567 voice

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Jürgen Fuchsberger 2014-02-13 15:41:24 Re: Backup of shut down standby does not work?
Previous Message Theodotos Andreou 2014-02-13 10:09:22 Re: Error: pid file is invalid, please manually kill the stale server process.