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 01:00:37 |
Message-ID: | CAJNY3ivGC0VRk4MYsu1dCiLba6u4HcT34obOhc8UfpE2-UC-1g@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
2016-06-05 12:53 GMT+12:00 Patrick Baker <patrickbakerbr(at)gmail(dot)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 ?
From | Date | Subject | |
---|---|---|---|
Next Message | Venkata Balaji N | 2016-06-05 01:52:47 | Re: user logging info |
Previous Message | Patrick Baker | 2016-06-05 00:53:38 | Re: WAL segment NOT FOUND - Postgres 9.2 |