Re: postgresql 9.4 streaming replication - Mailing list pgsql-general

From Andres Freund
Subject Re: postgresql 9.4 streaming replication
Date
Msg-id 20151019090904.GB3485@alap3.anarazel.de
Whole thread Raw
In response to Re: postgresql 9.4 streaming replication  (Sven Löschner <sven@someko.de>)
List pgsql-general
On 2015-10-19 08:34:51 +0000, Sven Löschner wrote:
> My client recovery.conf looks this way:
>
> standby_mode = 'on'
> primary_conninfo = 'host=arcserver1 port=5432 user=postgres pass=postgres'
> restore_command = 'pg_standby /db/pg_archived %f %p >> /var/log/standby.log'
> primary_slot_name='standby1'

pg_standby is for a "warm standby" - instead of signalling an error if
an archive file does not exist it'll sleep. Thus this node will never
enter streaming replication. Use cp or something instead.

Greetings,

Andres Freund


pgsql-general by date:

Previous
From: Andres Freund
Date:
Subject: Re: ERROR: tablespace "archive2" is not empty
Next
From: Josip Rodin
Date:
Subject: Re: ERROR: tablespace "archive2" is not empty