Re: BUG #18666: Standby cluster does not start after building from Primary cluster. - Mailing list pgsql-bugs

From Tom Lane
Subject Re: BUG #18666: Standby cluster does not start after building from Primary cluster.
Date
Msg-id 1551043.1729520412@sss.pgh.pa.us
Whole thread Raw
In response to BUG #18666: Standby cluster does not start after building from Primary cluster.  (PG Bug reporting form <noreply@postgresql.org>)
List pgsql-bugs
PG Bug reporting form <noreply@postgresql.org> writes:
> Standby cluster does not start after building from Primary cluster. 

I think your archiving setup is broken:

> archive_command = 'cp %p /dev/null'
> ...
> restore_command = 'cp /opt/archivelog/%f %p'

BTW, "cp" is widely regarded as not being safe enough for production
archiving, because it doesn't fsync.  But this archive_command
isn't even trying.  So it's not surprising if there's not enough WAL
to recover from.

            regards, tom lane



pgsql-bugs by date:

Previous
From: "David G. Johnston"
Date:
Subject: Re: BUG #18667: Default Permission Role Group
Next
From: Tom Lane
Date:
Subject: Re: pg_ident.conf + regular expressions issue