Postgres Pro
Downloads
Home   >   mailing lists

Re: WAL segment NOT FOUND - Postgres 9.2 - Mailing list pgsql-admin

From Patrick Baker
Subject Re: WAL segment NOT FOUND - Postgres 9.2
Date
Msg-id CAJNY3ivGC0VRk4MYsu1dCiLba6u4HcT34obOhc8UfpE2-UC-1g@mail.gmail.com
Whole thread Raw
In response to Re: WAL segment NOT FOUND - Postgres 9.2  (Patrick Baker <patrickbakerbr@gmail.com>)
Responses Re: WAL segment NOT FOUND - Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-admin
Tree view


2016-06-05 12:53 GMT+12:00 Patrick Baker <patrickbakerbr@gmail.com>:
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?

Current recovery.conf:
#primary_conninfo = 'host= port=5432 user=replicator application_name='
restore_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/restore.bash "../wal_archive/%f" "%p" 345600' 

New recovery.conf (To set streaming replication on):
primary_conninfo = 'host=mymasterserver port=5432 user=replicator application_name='
restore_command = 'exec nice -n 19 ionice -c 2 -n 7 ../../bin/restore.bash "../wal_archive/%f" "%p"'


By doing that, I'd active streaming replication on my backup server.

After the database be updated, I can go backup to the replication by wal files ?

pgsql-admin by date:

Previous
From: Patrick Baker
Date:
Subject: Re: WAL segment NOT FOUND - Postgres 9.2
Next
From: Venkata Balaji N
Date:
Subject: Re: user logging info