X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id D8B785348F for ; Wed, 13 Apr 2005 11:26:19 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50606-05 for ; Wed, 13 Apr 2005 14:26:17 +0000 (GMT) Received: from sss.pgh.pa.us (sss.pgh.pa.us [66.207.139.130]) by svr1.postgresql.org (Postfix) with ESMTP id 56AD153492 for ; Wed, 13 Apr 2005 11:26:16 -0300 (ADT) Received: from sss2.sss.pgh.pa.us (tgl@localhost [127.0.0.1]) by sss.pgh.pa.us (8.13.1/8.13.1) with ESMTP id j3DEQ9F5007044; Wed, 13 Apr 2005 10:26:09 -0400 (EDT) To: "Mohan, Ross" Cc: pgsql-admin@postgresql.org Subject: Re: question about wal and point in time recovery In-reply-to: References: Comments: In-reply-to "Mohan, Ross" message dated "Wed, 13 Apr 2005 13:51:09 -0000" MIME-Version: 1.0 Content-Type: multipart/mixed; boundary="----- =_aaaaaaaaaa0" Content-ID: <7026.1113402244.0@sss.pgh.pa.us> Date: Wed, 13 Apr 2005 10:26:09 -0400 Message-ID: <7043.1113402369@sss.pgh.pa.us> From: Tom Lane X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL X-Spam-Level: X-Archive-Number: 200504/171 X-Sequence-Number: 17184 ------- =_aaaaaaaaaa0 Content-Type: text/plain; charset="us-ascii" Content-ID: <7026.1113402244.1@sss.pgh.pa.us> "Mohan, Ross" writes: > In any case, do you have a pointer to this R&R WAL tool? I haven't posted it anywhere, but here is the 8.0 version. You'd build it something like this: PGSQL=(location of PG source tree) CC=gcc CFLAGS=-Wall -O -I $(PGSQL)/src/include xlogdump: xlogdump.c $(CC) $(CFLAGS) -o xlogdump xlogdump.c $(PGSQL)/src/backend/utils/hash/pg_crc.c It needs improvement to understand more WAL record types, but what it does has been sufficient for my debugging needs to date. Ideally someone would clean it up and make it into a contrib module so it could get into the source tree and be maintained properly ... regards, tom lane ------- =_aaaaaaaaaa0 Content-Type: application/octet-stream Content-ID: <7026.1113402244.2@sss.pgh.pa.us> Content-Description: xlogdump.c.gz Content-Transfer-Encoding: base64 H4sICNUqXUICA3hsb2dkdW1wLmMA7RprcxpH8jP8igk5bJDQw47PcSTLKYSwRAUBBnxR4rioZXeA LS271D5kKYnut193z8zO7ANJd/Hdp0u5InZmuqdf06+Zg529r/Vfle3AP3brBUsnWW/2bfiqVCbu euNxlsSu58Z3bBGEDGddf8lGQRQvQz750GdX/eE5W7gej/Ylmo+RteRHKTb6gQvYJ/1zf3+ffWbv giTeJLGAQ9BREMZu4EesE2zuQne5ilnDbrIXP/zweu/l4eGrlrnzuRfMLY+d8RvuBZs192N2HgbJ 5mFEgGPMl7A4YsGCxSvOPvruDQ8j5BFGOpbnAqu+a0ma/qa3/JsY+ppyP6hWv3V920sczmobsVO0 v6oZw28Xth97+6t3xlDiu1Hs4JgBbtk2j6IDG4SMGAoTqzjZlE7cWnZcPgGoZq4f89C3vOwK24ot mD3YLGd24MdhQPPVahRbsWszAKpUKrDgvXNcqRzssGvAwT32/owMyU7CEBXm+qB/Mh8UhYSdumve d33eO0ME035PYFAwMCYgYljnwToDNIF9v3tJG/ecLWCuUw4w4cstEBFfknlpMA01AmMfLhbHCBgs FhGP0YoUig3MwuI8h6l0xtwuAvv8NmYht4PQQVjCoWHtlRUCMI6eJosFDz+d9js/TX79fGzSngO6 6tNeoziswArxi9YDDa4Np8hyHDC8yKRdUlCKZBPym4ex4Ao3SKIiGsEAY2wn5JYzpmnghJ2wwcd+ /5gBvnE6AeBR4sXMgrUlastgmLi/c8ByeJxaIVhmFNOGcJDFx/hy5ltrHn2CH5ftq1nvbPfFZ4D6 o1qpkS+rtSr4H1BxiBvCaLszNUZfiNHJ5fnYGH0pRjtZDN+J0bPT9qSrR1+J0enpZNTRo38Xo+NL xl7r0dd69Hs9+r0efaNH3+jRH/ToD2L0otsemVxI5k6n465B2gvJ3UV7cmGuluyNc6slf+e9SUZC ksFJ9wNjtUo6TBzeg3aqUsXM8gPwwCFZa4u5YDVBFLnzzFmZB4FXRT2j+eFpa9wErtOsgsIiUPgs Zj7OggrxT4NcTovp49Fi4nw0YeMKbNGQy0/UeLUCqIyjzHbV1DGMI0Sjofa+AFAeNg30zb13t95m trbgBLBvTigezkbt8y5Y13mvA9gJPZwYMNlFo3YaLOFQ0PEUMH6ynoMI6oevrpgVKzdQv/rNr7UQ EE/KUwloMc1GE6m/r+IZiZPQZ3GYcBi6N4UA9B5K/heSQAgrPASh1UYWhFA400QqHOi6w+Z3MY+Y u/SDkDtInxB9U6CV+ywsL4KN7lHLGD87486eveL2NWhbZAvCI+wz9jNnTsDABtgcHDnEcYrHGE5U fJYgiEf6kYawmHgFU3FAAGvXd9dAKbhN9FvowoI1xBXMVHDeWgcJjSMaB+IWAhL/rt9kMOV67At/ DtsTndwhKKA7TWmAUCuKkjX88TyVN0iCVlYE5HNfYQTca74OwjvU5o7ktZo3aOG0etE/IN1wGtKz kp8UEC3D2+JOmzgkk7dD+/WrCv451h/zZAFfIqi48CsNakDViaQTrWQGAwiGDhj979y7xkMBp7FD CgKWkblwvQyFnCzfSdkkw6OD3Rv0pjNY+/pVAyhA7XeGlyM9ktJ+zuMzQNMQKJpgndwvW95Ainaa aqtdhgc7WDSIvyadAiAX3ftwYYhqL7sOMb/vDTKUCWP/pvtBjhqyoJ1xlTwA6oDq2HPE5qBRLQ0U j+srKkG79eSgfvgmPalCTfuYNLmgQPWJ6+VxFEekQUdEnJqs9Mnm55Z9nWzY3Avs64i8ouXfkeBB X6BPKa1yGYPwhJIxy2q4FA6Zy96CSsYU705/Gs1O+0NwbzC+uyuZJymZ0nH9RcCeEdSkO9VQDbeJ AgOjg1Pq+uhS4KtoEQUdI+2pYk+vN6fIXtNwzo+AGLaAxpBHVGYMBWuoVOBk2pu7hhThMzw5tE+r AK2EkpqOWCsNJuvT8yYzv5bqQ6f5mNVUQD277IW2l+3mU7Af8u8kppOiRHZ1FEM7k7AYBpqGe27H MV9v4tQlZp208GeZLKvMl6lpHZq1j6EgBTQUfZwc7IAlqQkqJdSk4caEpOIAag7pxBI/gkDEHXJ4 wvUBh6ELAUqkgJA4xhDCjqqVLyvMvhtpus3ewgr2559Mj7yTsgIzyrsZeULgmA44hoYAstwby7c5 /vT5lzTVlgbDMrmKOCzZ0Ghk/uyEZSM77v5gtNc5yeM5gTzE/7zqj2b94eB8BkngWXfcVHE/a8Uf oe7YcDsGJmXZAtALz1pGfzk5QVSF3ER7PvRVFpMexcLC3agaKk/OwVKfNZq9740n01lvMusMB5Cz dobjM1IEMZxyPLl2N9TPSDTrZVSUco6s5zmqaPtFR5237iZraKLRUyszkNDaLOA8g7Nu93vng4bG SZ455Gs8AgCuLVVvIjDdC9eAxz4t96RjAbpEcZyZEk5GzEEdDH4B0cIvqql2mZkda7KP0auYzD6F URGSs0kJZuOHD8RhucsXN16x33kYYIwrcaWgkTy7LVbgkkR0kPN8dnADlILK1YmGsJDEbOlCVgjB 2FrEHG10wb9g64rM0jzEh+pY7u4qL/SOvSo9+8uANiTnJBJncMQVTJQpaUW3Al4OOVwCt5iOKU+M nRe0VkwHrM2G+w7YayZb2EdEQFvqKIG0Qtq0W8gIv3UXgGvBhv2zWb87OJ9ezH5u//K/zCEM3/54 LPsWOHcX1VRwbQ8WWSA5IJf7nhUueTZkQfIOeuUgLig6puDAMUyxJOIejyJCEa0xsQcRA1zEIesK oWQAmUMVgrSQ12frxItdbImCUgQ5LcqQ19Y1F1iSENxm/DxC2/QAU8xe7cjAAhhI5WTEQEZjuoJF bgQUB8lyJXyg5xGeGhRYQFBNKioStggGescEd1DfrN0Y+bXmQahaNRFUQtjpRFYJD1QhnEUby+b7 TWkZqCQt6nes0ECRylSxF46DbKsYwbeqx9NaGSJnQw3WzaxOY7i0btWSFjZBzFXCJxi0kIEsQs5z wyKNzvaNGqLD02SoxcBWm6SIvylg/kOczNLmkYhMUPKB1wUVxStQEhiQxWpzqt2xFqhhnHBcChIi RhXqZ3ls5TmuJ+Svrg7qVyBJcGCBv9ShJJVt68kOrOBX7qvlHElhyCxQpGOyWZIuhUnhLFJdFmOD Uio16Kwby/UsbNRAaitS3TLrwnqvkD7hEYv4GoHNKK8sDh2kIEbZmkza57KdowpkWUxuDUFp5qmY 3pUoK8KxHR+nliD33mTSMNp7e04nUgng6+rqiuERpkgy54zEUkwTdav7G2kyRZv56CtgysUzuQgS 9yOYjMwV8uon/Usf/NdzpZJkyYzH2ILh6Lz8gBkJDiaLaBDqlgeMPoJkAv6QASX53KnntGTCUUwO tzCYVdF/lj7/m1ladkuBAeW8JS87kcVFtmLBlHt7JidM/jGpu/4NdovILPa0e0H5PlXo5RS0/kNl 5HxGTjd7pQnqY+JTTkMJInf4las3VFieCGv/kHoUff5LXEI2GxH8bdmbPb559UF5C7LM/DFN9nMy LEcPww8hnoPzuFYhgTxCttuoHGjq48uL1ELfmLr2IheNiADLhQIcbY9iZFoHb/HX6VloPlA3pE67 vBbK4HgyaznOMozdV817KbYDX+EMbxYb+L8ZOHU/+CJuG4xlQOan715+xhAB6xe0nvpDMnOF37Jv Wav/sldf79UdVr84ql8e1Ses/qssVzBt9Qj2Ge1C1ZGkjnq6mjjMWKt4na7FVdI1JjqpGeLKPm/a 5qUY96ZCfj/TE9ZNgvGsN3g/hAx/8hMSolyQLLKO2Ca8URUXMfC0ckuuNHbEq0GzzZUdT3McqeCr /uldzLsfGrmVLaYvIUnLit7Gj81a02TgmN2C16wnx6yW2Q9Gy+rRcA2r356w9ILQRF6PAEd6h5iD +oxWycHIzDL2ktVfOtmNcW2GQtFrqR++vJIOnS5Xckpq5eo2wvC0lnDhCuDfq+xUHcbY/HquW6Ml tV6jvNgrVHvSRTwDfNn+a1rykStT8plfb1Q/FZKPCIObM8f/h9zDP3IyMRoB7u4L9RM22fcDh+9H G3sAf1t6xJnnBgAhjRighJzIeWKnNYISz14VbEoK04YCEy2ILgp7Z0cqHoqTKS8QOxfdzk+jYW8w nU0uPk7Phj8PIKegqLJt3XDQ7w26RuSk3tooQHewQxdbG/yN1qJnwOOWG81xJgvR4NiLcQLlBo4Z VMnGV+y5eM5ADWnGUWP0nkGdQPwdyN91qpPrUTZDSbfae4dbacdSmND+pQiKdJWCiomHQKcQzPQT lCw0kn+FKEshcXboOhrto0ptsh+1pKJVEjvBF7/Gjlgt8PFpiyGYNC6ZO+JAU/f8yPmwgjUNulfT Yc/sgAKVWJkTuaLOSY+kYmLrJZ40f1jTzJmJBD1SDkx+G/SlqUl6Ctqd6dZTQJOd4eVlb2rQjp7b suOZaILAJ1CW44HGHuWAVuV5EFiPVMEe5T3xranfVCeEav/2aeogttqnw3EZV9TQ+dpMEdKvxFNB hZ0tjozGf+2Oh/gawuCU8hNMFv0gx6EYfJRFQJBnkJrC+PBNZKGHt/XDV7fEpsD5EP34kkfRX5jE ZzNqUvn1tHYenov54QhzJoNFgtbzvcGkO54SDrkA1b3iFtbhEQ9jZur7ryg8FYjAW48eDJeFClH7 rGcZ8ntTetIC3orVdvGTXJQJJYwlxu5knA22D62R4fehJWZAFmt6MV9T8OIhyIRC8IDe0EiJKfAY PM9WsCHd52yFU+JM7UEaT16zZ91+d9ot1azDPR7zr69Zgff/mv0va/bj6KytNGsuzi27HP7j8UWd frc9KKwq90b0IG+7O2pPLrZOjh8ExUd6Wycn3Q/5uXusPkvLT3TAbEF5FVQdbIG1kL7036HvuRVx s8L5zQeL/c0nlywAjtP7m+5tHELoSztYrkPXKurV7SIM1uIBLcLJe4x0E8hnIWKF9ips0FiLPT94 rroD6Sr0zenH7q4u00w89FtCRpFt+QuNoAWF/Jtb8Q9YeCYeJosf2Dl7JlpndLX+3bYndR3Lfy4u a5Y+dncUw7gJe16PnmvxENHyqQBspG5t9Q2tuKq4r4o31ki9I7om6p72hO3JqoS61FHAXkSxuOJa i6fXma42XXVG8s1r/mpTvqAwHnqoV1O5lkSum1O8utE1O6DWT5GluYG4qmvL9cnC4Mza0sZ28ONG dTeYi5aVlrAvRAmLy82iVbRzSJiwCOE/uZ/pRoisF8aCDfeV0Qxn4zOooH5hf7LR+ey0N2iPf2mx Q/0QCCDemo8mQKOBNDndVFbl7b0hmQaeFL0OkpSIw1gz8ywHpXxfVW9yxgE+XuTq0hIzSPH8LmJf sPEOWy3cZQJVEF0btieYXtCzHHyPU6ng/UoYzzjdJiCnotVF4u3e2nyDFwqW11FXWLKxmV5pDVAk MiEUU8Tt9G6TG0brNRejaLFsEd6X9FU4BNNxewSpaNT4rQaZKNj7e0ByxNQXVl0w7TRV7NJbsyKB KQHmtqgzyngbzeOsgP8FX6ArozQzAAA= ------- =_aaaaaaaaaa0--