On Mon, Jan 15, 2018 at 12:13:46AM +, Dylan Luong wrote:
> The content of the history file 0006.history is:
Please do not top-post. This breaks the logic of the thread.
> $ more 0006.history
> 1 2CE/8A98no recovery target specified
> 2 2CE/FF974EF0no recovery t
not from C0?
Dylan
-Original Message-
From: Michael Paquier [mailto:michael.paqu...@gmail.com]
Sent: Saturday, 13 January 2018 9:04 PM
To: Dylan Luong
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Missing WAL file after running pg_rewind
On Fri, Jan 12, 2018 at 09:44:25PM +
On Fri, Jan 12, 2018 at 09:44:25PM +, Dylan Luong wrote:
> The file exist in the archive directory of the old master but it is
> for the previous timeline, ie 5 and not 6, ie
> 0005038300BE. Can I just rename the file to 6 timeline? Ie
> 0006038300BE
What are the conte
]
Sent: Friday, 12 January 2018 12:08 PM
To: Dylan Luong
Cc: pgsql-general@lists.postgresql.org
Subject: Re: Missing WAL file after running pg_rewind
On Thu, Jan 11, 2018 at 04:58:02PM +, Dylan Luong wrote:
> The steps I took were:
>
> 1. Stop all watchdogs
>
> 2.
On Thu, Jan 11, 2018 at 04:58:02PM +, Dylan Luong wrote:
> The steps I took were:
>
> 1. Stop all watchdogs
>
> 2. Start/stop the old master
>
> 3. Run 'checkpoint' on new master
>
> 4. Run the pg_rewind on old master to resync with new master
>
> 5. Start the
Hi
We had a failover situation where our monitoring watchdog processes promoted
the slave to become the new master.
I restarted the old master database to ensure a clean stop/start and performed
pg_rewind on the old master to resync with the new master. However, after
successful rewind, there w
