| From: | Ankur Kaushik <ankurkaushik(at)gmail(dot)com> |
|---|---|
| To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
| Subject: | Slave show ahead of the WAL error |
| Date: | 2016-08-11 12:51:26 |
| Message-ID: | CALXoLqyQc+FZ5knCc0U+ir5=xSE9uJG+bNK1FCquXN+k0N=EXQ@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-admin |
I stopped the slave PostgreSQL
apply
mv recovery.conf recovery1.conf
Started PostgreSQL
Change pg_hba.conf added new IP
Now
mv recovery1.conf recovery.conf
STARTED Slave Postgresql
Now Error Showing on Slave
< 2016-08-11 18:16:36.409 IST >LOG: started streaming WAL from primary at
5/E1000000 on timeline 1
< 2016-08-11 18:16:36.409 IST >FATAL: could not receive data from WAL
stream: ERROR: requested starting point 5/E1000000 is ahead of the WAL
flush position of this server 5/E000EDD8
Error Showing on Master
< 2016-08-11 18:11:32.157 IST >LOG: replication connection authorized:
user=repl
< 2016-08-11 18:11:32.214 IST >ERROR: requested starting point 5/E1000000
is ahead of the WAL flush position of this server 5/E0012708
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Keith | 2016-08-11 13:23:29 | Re: Slave show ahead of the WAL error |
| Previous Message | dbyzaa@163.com | 2016-08-11 06:24:49 | how can I know WAL insert location When the primary crash |