Re: recovery.conf - Mailing 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