From: | Vladimir Borodin <root(at)simply(dot)name> |
---|---|
To: | Michael Paquier <michael(dot)paquier(at)gmail(dot)com> |
Cc: | PostgreSQL mailing lists <pgsql-hackers(at)postgresql(dot)org> |
Subject: | Re: pg_rewind and xlogtemp files |
Date: | 2015-06-17 07:57:51 |
Message-ID: | FAD4FB4F-9C7C-4D7F-8BC1-BC61861F006A@simply.name |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
> 17 июня 2015 г., в 9:48, Michael Paquier <michael(dot)paquier(at)gmail(dot)com> написал(а):
>
> On Wed, Jun 17, 2015 at 3:17 PM, Michael Paquier
> <michael(dot)paquier(at)gmail(dot)com> wrote:
>> As pointed by dev1ant on the original bug report, process_remote_file
>> should ignore files named as pg_xlog/xlogtemp.*, and I think that this
>> is the right thing to do. Any objections for a patch that at the same
>> time makes "xlogtemp." a define declaration in xlog_internal.h?
Declaration seems to be the right thing.
Another problem I’ve caught twice already in the same test:
error reading xlog record: record with zero length at 0/78000090
unexpected result while fetching remote files: ERROR: could not open file "base/13003/t6_2424967" for reading: No such file or directory
The servers diverged at WAL position 0/76BADD50 on timeline 303.
Rewinding from Last common checkpoint at 0/7651F870 on timeline 303
I don’t know if this problem could be solved the same way (by skipping such files)… Should I start a new thread for that?
>
> And attached is a patch following those lines.
> --
> Michael
> <20150617_rewind_xlogtemp.patch>
> --
> Sent via pgsql-hackers mailing list (pgsql-hackers(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-hackers
--
May the force be with you…
https://simply.name
From | Date | Subject | |
---|---|---|---|
Next Message | Haribabu Kommi | 2015-06-17 07:59:05 | Re: Auto-vacuum is not running in 9.1.12 |
Previous Message | Prakash Itnal | 2015-06-17 07:36:28 | Is Postgres database server works fine if there is a change in system time? |