Re: recovery.conf - Mailing list pgsql-admin

From Poul Kristensen
Subject Re: recovery.conf
Date
Msg-id CAAOuvVpQf74L4FwqMm+-We76uHKB=Ohj3sbfb0mkq78eLzzCXA@mail.gmail.com
Whole thread Raw
In response to Re: recovery.conf  (Albe Laurenz <laurenz.albe@wien.gv.at>)
Responses Re: recovery.conf
Re: recovery.conf
List pgsql-admin
Thanks a lot for fast responce.

Do you have any idea of why PostgreSQL don't use cluster like normally used  e.g 
One common disk for both master and nodes?

Thanks. 

Poul

2016-09-05 14:24 GMT+02:00 Albe Laurenz <laurenz.albe@wien.gv.at>:
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



--
Med venlig hilsen / Best regards
Poul Kristensen
Linux-OS/Virtualizationexpert and Oracle DBA

pgsql-admin by date:

Previous
From: Rory McCann
Date:
Subject: Index bloat? Try pgindexrebuild, a production friendly index debloater
Next
From: Poul Kristensen
Date:
Subject: Re: recovery.conf