Re: [HACKERS] Proposal: pg_rewind to skip config files

Поиск
Список
Период
Сортировка
От Chris Travers
Тема Re: [HACKERS] Proposal: pg_rewind to skip config files
Дата
Msg-id CAN-RpxDhc_8JOq=cT9vd6MqWQaS0ZtvSf2LFV1V+bjOoEz02ow@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [HACKERS] Proposal: pg_rewind to skip config files  (Vladimir Borodin <root@simply.name>)
Список pgsql-hackers
One more side to this which is relevant to other discussions.

If I am rewinding back to before when a table was created, the current algorithm as well as any proposed algorithms will delete the reference to the relfilenode in the catalogs but not the file itself.  I don't see how an undo subsystem would fix this.

Is this a reason to rethink the idea that maybe a pg_fsck utility might be useful that could be run immediately after a rewind?

--
Best Regards,
Chris Travers
Database Administrator

Tel: +49 162 9037 210 | Skype: einhverfr | www.adjust.com 
Saarbrücker Straße 37a, 10405 Berlin

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Fabien COELHO
Дата:
Сообщение: Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: [HACKERS] Re: [COMMITTERS] pgsql: pg_rewind: Fix some problemswhen copying files >2GB.