Re: Hot Backup with rsync fails at pg_clog if under load
| От | Simon Riggs |
|---|---|
| Тема | Re: Hot Backup with rsync fails at pg_clog if under load |
| Дата | |
| Msg-id | CA+U5nMLvMp8ikF+9HYaJEtqUQyJkP5WHBEqZqbBswn6KDwCx1Q@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Hot Backup with rsync fails at pg_clog if under load (Chris Redekop <chris@replicon.com>) |
| Ответы |
Re: Hot Backup with rsync fails at pg_clog if under load
|
| Список | pgsql-hackers |
On Sun, Oct 16, 2011 at 2:33 AM, Chris Redekop <chris@replicon.com> wrote: > pg_subtrans: http://pastebin.com/qAXEHAQt I confirm this as a HS issue and will investigate from here. FATAL: could not access status of transaction 21110784 which, in pg_subtrans, is the first xid on a new subtrans page. So we have missed zeroing a page. pg_control shows ... Latest checkpoint's oldestActiveXID: 21116666 which shows quite clearly that the pg_control file is later than it should be. Chris, can you rearrange the backup so you copy the pg_control file as the first act after the pg_start_backup? -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
В списке pgsql-hackers по дате отправления: