Re: WAL segment NOT FOUND - Postgres 9.2

From: Patrick Baker <patrickbakerbr(at)gmail(dot)com>
To: Ian Barwick <ian(at)2ndquadrant(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org
Subject: Re: WAL segment NOT FOUND - Postgres 9.2
Date: 2016-06-05 00:53:38
Message-ID: CAJNY3itE11OWxBknSThF2+_N2wpZj1AGGDpz5a27efGMR9v0NA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Hi guys,

So... My servers are:

1 master
2 slaves (streaming replication)
1 backup server (replication using WAL FILES)

The backup server is not updated... it seems the WAL ARCHIVES have failed
and the server is not updated.

The error that I see on the pg_log:
WAL segment `../wal_archive/00000002000011E800000012` not found

Question:
Can I make the server be replicated by using streaming replication, so the
server would be updated.. and then I go back to the WAL ARCHIVE?

We use WAL ARCHIVE because we keep it 4 days old:
restore_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/segment.sh
> "../wal_archive/%f" "%p" 345600'

Thanks

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Patrick Baker 2016-06-05 01:00:37 Re: WAL segment NOT FOUND - Postgres 9.2
Previous Message Bear Giles 2016-06-03 15:07:25 Re: GSSAPI / Kerberos Authentication