Re: [HACKERS] Proposal: pg_rewind to skip config files - Mailing list pgsql-hackers

From Chris Travers
Subject Re: [HACKERS] Proposal: pg_rewind to skip config files
Date
Msg-id CAN-RpxDhc_8JOq=cT9vd6MqWQaS0ZtvSf2LFV1V+bjOoEz02ow@mail.gmail.com
Whole thread Raw
In response to Re: [HACKERS] Proposal: pg_rewind to skip config files  (Vladimir Borodin <root@simply.name>)
List 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 by date:

Previous
From: Fabien COELHO
Date:
Subject: Re: [HACKERS] pgbench: Skipping the creating primary keys afterinitialization
Next
From: Alvaro Herrera
Date:
Subject: Re: [HACKERS] Re: [COMMITTERS] pgsql: pg_rewind: Fix some problemswhen copying files >2GB.