Re: Interrupted streaming replication

From: Andreas Kretschmer <akretschmer(at)spamfence(dot)net>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Interrupted streaming replication
Date: 2015-12-07 13:45:33
Message-ID: 20151207134533.GA17039@tux
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Tony Nelson <tnelson(at)starpoint(dot)com> wrote:

> 2015-12-07 08:24:50 EST FATAL: requested WAL segment 00000001000000890000002C
> has already been removed
>
>
>
> Can I simply copy the file from my archive directory back to the WAL directory?

I'm afraid that won't work, because of the master knows nothing about
this copy and can't stream its content.

Maybe you can create/update your recovery.conf, see restore_command.

for the future: increase wal_keep_segments, or better: use replication
slots (since 9.4 a really good feature to prevent such errors).

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Nelson 2015-12-07 13:50:50 Re: Interrupted streaming replication
Previous Message Tony Nelson 2015-12-07 13:25:08 Interrupted streaming replication