Zdenek Kotala wrote:
The original proposal (http://archives.postgresql.org/message-id/[EMAIL PROTECTED]) contains two parts. First part is implementation of --footprint cmd line switch which shows you page layout structures footprint. It is useful for development (mostly for in-place upgrade) and also for manual data recovery when you need to know exact structures.

I'm afraid I still fail to see the usefulness of this. gdb knows how to deal with structs, and for manual data recovery you need so much more than the page header structure. And if you're working at such a low level, it's not that hard to calculate the offsets within the struct manually.

BTW, this makes me wonder if it would be possible to use the upgrade-in-place machinery to convert a data directory from one architecture to another? Just a thought..

However, there is still --footprint switch which is useful and it is reason why I put it on wiki for review and feedback. The switch could also use in build farm for collecting footprints from build farm members.

If we needed more information about the architectures, we could just collect the output of pg_controldata. But I think the configure logs already contains all the useful information.

--
  Heikki Linnakangas
  EnterpriseDB   http://www.enterprisedb.com

--
Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-hackers

Reply via email to