Postgres Pro
Downloads
Home   >   mailing lists

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

From Venkata Balaji N
Subject Re: WAL segment NOT FOUND - Postgres 9.2
Date
Msg-id CAEyp7J9kAoKiuiRNa8VHKx4azbqSgQa4gCyCiH2xT8YriD4rLg@mail.gmail.com
Whole thread Raw
In response to Re: WAL segment NOT FOUND - Postgres 9.2  (Patrick B <patrickbakerbr@gmail.com>)
List pgsql-admin
Tree view

On Tue, Jun 7, 2016 at 9:53 AM, Patrick B <patrickbakerbr@gmail.com> wrote:
Can I update the database just by setting the server as slave using streaming replication?

Or I have to re-sync all the data folder and then set it as slave with streaming replication?

If you are replaying WALs continuously without any issues, then, you can just add standby_mode='on'  and then, restart the standby database, that should do.


Regards,
Venkata B N

Fujitsu Australia

pgsql-admin by date:

Previous
From: Max Kremer
Date:
Subject: Re: Planner is ignoring index when view is queried but uses index when running underlying view's sql
Next
From: jonescam
Date:
Subject: Looking for Beta Users!