| From: | Andres Freund <andres(at)anarazel(dot)de> |
|---|---|
| To: | Sven Löschner <sven(at)someko(dot)de> |
| Cc: | Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>, pgsql-general(at)postgresql(dot)org |
| Subject: | Re: postgresql 9.4 streaming replication |
| Date: | 2015-10-19 09:09:04 |
| Message-ID: | 20151019090904.GB3485@alap3.anarazel.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Josip Rodin | 2015-10-19 09:14:33 | Re: ERROR: tablespace "archive2" is not empty |
| Previous Message | Andres Freund | 2015-10-19 09:06:59 | Re: ERROR: tablespace "archive2" is not empty |