Re: recovery.conf

[Poul Kristensen <bcc5226@xxxxxxxxx>]

Sorry for asking a lot.

 pg_replication_slots.

is this meant to be a slot like a ethernetcard and controller in a physical server. 

Thanks a lot.

/Poul 

2016-09-06 10:41 GMT+02:00 Poul Kristensen <bcc5226@xxxxxxxxx>:

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@xxxxxxxxxx>:

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

--

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