Re: recovery.conf - Mailing list pgsql-admin

From Albe Laurenz
Subject Re: recovery.conf
Date
Msg-id A737B7A37273E048B164557ADEF4A58B5389858F@ntex2010i.host.magwien.gv.at
Whole thread Raw
In response to recovery.conf  (Poul Kristensen <bcc5226@gmail.com>)
Responses Re: recovery.conf  (Poul Kristensen <bcc5226@gmail.com>)
List pgsql-admin
Poul Kristensen wrote:
> It is not obvious to me what is the minimum configuration of the recovery.conf?
> 
> The online manuals does not give the exact minumum.
> 
> Can anyone help?

None of the settings in recovery.conf must be specified.

One that you will almost always have for recovery is "restore_command", but if all
the WAL you need is in pg_xlog, you don't have to specify that either.
And you don't need it for streaming replication.

Some settings are necessary for point-in-time-recovery, and some
for streaming replication, which are two different use cases for the same recovery mechanism.
Maybe that's what's confusing you.

Yours,
Laurenz Albe

pgsql-admin by date:

Previous
From: Robert Burgholzer
Date:
Subject: Re: Initiating log shipping backups when the initial filesystem-level backup went out of sync
Next
From: Rory McCann
Date:
Subject: Index bloat? Try pgindexrebuild, a production friendly index debloater