Re: How to perform PITR when all of the logs won't fit on the drive

From: Alan Hodgson <ahodgson(at)lists(dot)simkin(dot)ca>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: How to perform PITR when all of the logs won't fit on the drive
Date: 2018-03-01 22:34:47
Message-ID: 1519943687.10985.27.camel@lists.simkin.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Thu, 2018-03-01 at 17:28 -0500, Tony Sullivan wrote:
Hello,

I have a situation where something was deleted from a database that
shouldn't have been so I am having to take a base backup and perform a
point-in-time-recovery. The problem I have is that the decompressed WAL
files will not fit on the drive of the machine I am trying to do the
restore on.

Your restore_command can be a complex command or shell script that can
transfer WAL files as needed from a network source.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Daevor The Devoted 2018-03-02 04:10:43 Re: Enforce primary key on every table during dev?
Previous Message marcelo 2018-03-01 22:33:15 Re: Enforce primary key on every table during dev?