Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vo1tW-0000bH-33 for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 02:08:54 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.80) (envelope-from ) id 1Vo1tV-000326-4g for pgsql-hackers@arkaria.postgresql.org; Wed, 04 Dec 2013 02:08:53 +0000 Received: from makus.postgresql.org ([2001:4800:7903:4::125]) by malur.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vo1tT-00031x-Nf for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 02:08:52 +0000 Received: from tama50.ecl.ntt.co.jp ([129.60.39.147]) by makus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1Vo1tQ-0007Wv-8d for pgsql-hackers@postgresql.org; Wed, 04 Dec 2013 02:08:51 +0000 Received: from mfs5.rdh.ecl.ntt.co.jp (mfs5.rdh.ecl.ntt.co.jp [129.60.39.144]) by tama50.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id rB428cnL032048; Wed, 4 Dec 2013 11:08:38 +0900 Received: from mfs5.rdh.ecl.ntt.co.jp (localhost.localdomain [127.0.0.1]) by mfs5.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id E39D8E0069; Wed, 4 Dec 2013 11:08:37 +0900 (JST) Received: from imail3.m.ecl.ntt.co.jp (imail3.m.ecl.ntt.co.jp [129.60.5.248]) by mfs5.rdh.ecl.ntt.co.jp (Postfix) with ESMTP id D75FCE00F2; Wed, 4 Dec 2013 11:08:37 +0900 (JST) Received: from [129.60.241.67] ([129.60.241.67]) by imail3.m.ecl.ntt.co.jp (8.13.8/8.13.8) with ESMTP id rB428bfo020492; Wed, 4 Dec 2013 11:08:37 +0900 Message-ID: <529E8FE6.6040209@lab.ntt.co.jp> Date: Wed, 04 Dec 2013 11:13:58 +0900 From: KONDO Mitsumasa User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64; rv:24.0) Gecko/20100101 Thunderbird/24.1.1 MIME-Version: 1.0 To: fabriziomello@gmail.com CC: Pgsql Hackers , Andres Freund Subject: Re: Time-Delayed Standbys References: <52984711.8040806@lab.ntt.co.jp> In-Reply-To: Content-Type: multipart/mixed; boundary="------------090703080008050504050803" X-TM-AS-MML: No X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-hackers Precedence: bulk Sender: pgsql-hackers-owner@postgresql.org This is a multi-part message in MIME format. --------------090703080008050504050803 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 8bit (2013/11/30 5:34), Fabrízio de Royes Mello wrote: > On Fri, Nov 29, 2013 at 5:49 AM, KONDO Mitsumasa > wrote: > > * Problem1 > > Your patch does not code recovery.conf.sample about recovery_time_delay. > > Please add it. > Fixed. OK. It seems no problem. > > * Problem2 > > When I set time-delayed standby and start standby server, I cannot access > stanby server by psql. It is because PG is in first starting recovery which > cannot access by psql. I think that time-delayed standby is only delayed recovery > position, it must not affect other functionality. > > > > I didn't test recoevery in master server with recovery_time_delay. If you have > detail test result of these cases, please send me. > > > Well, I could not reproduce the problem that you described. > > I run the following test: > > 1) Clusters > - build master > - build slave and attach to the master using SR and config recovery_time_delay to > 1min. > > 2) Stop de Slave > > 3) Run some transactions on the master using pgbench to generate a lot of archives > > 4) Start the slave and connect to it using psql and in another session I can see > all archive recovery log Hmm...　I had thought my mistake in reading your email, but it reproduce again. When I sat small recovery_time_delay(=30000), it might work collectry. However, I sat long timed recovery_time_delay(=3000000), it didn't work. My reporduced operation log is under following. > [mitsu-ko@localhost postgresql]$ bin/pgbench -T 30 -c 8 -j4 -p5432 > starting vacuum...end. > transaction type: TPC-B (sort of) > scaling factor: 10 > query mode: simple > number of clients: 8 > number of threads: 4 > duration: 30 s > number of transactions actually processed: 68704 > latency average: 3.493 ms > tps = 2289.196747 (including connections establishing) > tps = 2290.175129 (excluding connections establishing) > [mitsu-ko@localhost postgresql]$ vim slave/recovery.conf > [mitsu-ko@localhost postgresql]$ bin/pg_ctl -D slave start > server starting > [mitsu-ko@localhost postgresql]$ LOG: database system was shut down in recovery at 2013-12-03 10:26:41 JST > LOG: entering standby mode > LOG: consistent recovery state reached at 0/5C4D8668 > LOG: redo starts at 0/5C4000D8 > [mitsu-ko@localhost postgresql]$ FATAL: the database system is starting up > FATAL: the database system is starting up > FATAL: the database system is starting up > FATAL: the database system is starting up > FATAL: the database system is starting up > [mitsu-ko@localhost postgresql]$ bin/psql -p6543 > psql: FATAL: the database system is starting up > [mitsu-ko@localhost postgresql]$ bin/psql -p6543 > psql: FATAL: the database system is starting up I attached my postgresql.conf and recovery.conf. It will be reproduced. I think that your patch should be needed recovery flags which are like ArchiveRecoveryRequested and InArchiveRecovery etc. It is because time-delayed standy works only replication situasion. And I hope that it isn't bad in startup standby server and archive recovery. Is it wrong with your image? I think this patch have a lot of potential, however I think that standby functionality is more important than this feature. And we might need to discuss that how behavior is best in this patch. Regards, -- Mitsumasa KONDO NTT Open Source Software Center --------------090703080008050504050803 Content-Type: application/x-gzip; name="conf.tar.gz" Content-Transfer-Encoding: base64 Content-Disposition: attachment; filename="conf.tar.gz" H4sIAAo7nVIAA+RcW3PbOLLO6/hXYKzjVXJKUiQnTqaSk9nj2J6Md33J2PJk 54kFkZDENUUwBGlbeTi//XzdAHiRb5rZcdW5qFKVkGg0gEaj++tGM6FOpy+f Pe1viN/btzv27zevW3+737PR9vbrt9uvdl4PR8+Go+3R6O0zsfPE8+JfaQqZ C/FsERem7F/q++gea/9f+gtp/zNtilmuzNdkQM8Dk8gr9eeNQRv8Bnt89/7v 0EO1/9s7b7D/b16Nhs/E8M+bwv2//+f73xH9h34bHfHZKsf5L0eClCOelbks Yp2KaZyojUf7g2I8jw1TEwMTm8IIPRVJnCr+RzFXYqrzxTsmFiKVCyU+iCuZ lIpfPR+DYvPDpgAbndHYMhm8EOLLPC6UyWSoxEIuxUSJ0qhoIMSeXixUimFk rkScFrmOylBF4jou5uC32dkUMl1ezxWasRDJc0E/GifUiyxRhcI7U9D0Mplj QoXKeWLgmUZCJom+VhF48SyNCGVK4091idY45TU1BBfpsKQZseAGTig8Fr1V UV+XhTCqKOJ0ZoSZ6+vUcvGCy1WG8wla5hypqSyTwg0OfuJM9R0zcMCCHC+S 2MnpWJhyOo3DmPtrMLtSeSFifrjF7z3YLXUpUgWJMXWiZcR0RuXoOVjZVPyd K1BAkpZA0JEqyoxFBSmnjc4gDVV8RXIU54effr74DF4mntGWCnE45aFVFNuF Mn/eobxMU1qQWZpCLXpMNoeVohlaPtSBeNlhoFDMIZzLdIbRaKXyUgk1naqw 6Ak0Q1nEZjYLwiJxi9zEFM71gthUu256WEIczlmXFjK/hFQmoL7uodPXMsZb Wa17XhYR7R0tHPtFYsDIYNcY24pvN102NIvURyZGkw7NIB08kYBoS8GqT+rp NN9vmR2xJ9RgNuiRTnsbLvqhSDRWpdMUo6GL+aBTv7LGurzOWglBpwsSsihi Xj8dFR5o8/xgvCns6efZ2Pkfq4XOl6JMYRbfCXH5ESf2Mk70ZIkjKdxvDF4V yQKvP4hFnOBgKcwuMnzaW79jYrNQM9li0/rR2w/iXg6fiMMsfojDAieLJpKW oLjNYUwcIKAHOMx5DnNd5nf0X+MXcf9ILs3GxkbnQQP6u3+Y0E+HRwfi6HRv d3x4enL+pw/gjFfbCDlDjiN1JfNYThJlrW+UszpPc71gdervt7QavJxe40B+ /rS/O94VKr2Kc52SMauY9WoLCFVlw40Tssf+aD+GSdroRLKQQYTzGBakmR9E t2rufvddh4870ZBhlanGZHJRkW98Rz+4Gnsa/NE2/hS/2OjMJzJge9Tk/BL2 Aw0Mm7roP8cp7E+kofNUYgjY47DhLR8fJY7Q5+5xuKkaiZ/u8siPjgGZw86q G+g4rG6QxVHg7TjEgoYsga8okiV5kR7eEW0uxefD/crgX+dxUShyZbf5YN5d ngIRYZ/Slf5rzPAJDsXe6cnJwR6fCLF7si92L8Y/H5yMD+0peYpD0if9dDZY nHvnjiZCFioNZBRhxQYLh8T+nXX0eg4rfPhZuKbnyrwgg287wBG+97LjM9Q3 isw5nQgPViqeFaU7puwBu4kOZUI62n3P5wHDsqcEnnl8VzINb/ZBvNl5/eox 0oW8aTog9BoNh4+pvjjRhYKjOExD4AlD3n6VT6gJPP7X6+FQWOuMJZs57EwE r8EOKVP5BomnErxJNJQ4S0oDtxheCosXnxulmDu9MwF6BVDR1Eju9AJ6bUq8 hIzygMwOnG20sqJXD68Gbu8mMOCuisoqxXavXxaLrPvAJjbI17AYzYFmuQbs qg7gmr2w0EVsjFsXQvW31HmiZrCUjAOGpDykLzosZEJWgu3NGpOb6PSfcJNg q6dTSy0jQp/AAB41XcVSfLR063MMXJTgVtrU8sKh+NJj9rVMYh9HNCxhsZaM 3nbb1psOdNugBwSUCLZDt4EliP/I9BHmAhIYkzRX/MBqQBmEcTYnPIbF7B/8 tHtxNH73/dHpl3ffH/zj87vvj/d33v3n+fjs4OTT+GfSGhd7iPNzQDLbdQ2x 0UC5StVMF7GdfxIjpMWgO6Pt44/Ed4HgxeofecmJKq4VjE6rk3EzxgZWtt4F BWFedNeYw6VarvbEq3V6hnLFvTxGnyfrd8ikMdc6jwIF47O0iAQ7mAJWTAK2 Ahz8se3gnSWV+bvKJyrXNiT8dH6++/lwo3OZTwK7MFprNQHXkF95vfV43S69 YqXTZPnCEoeAEXFqeHhTj9oX473PGBtmI+FAqs9RD5A6UJV4K4ow22SjHqlC xgkgZgevMBnfAUCCJzWkkcEr+PvBAXzz0UGPoJFD1pX/GOJNAnNkbNjB4Zc/ brc5A57lAIS3uJ+Mfz3619mHrKErvPdOxutxewpUcXZwfnpxtncgLs53Px2I 5+omVFkhvuwevXgaSOHiLjxZvxdMENpb/Rht/4CDTGKgCAdPlx/XMAyQUNZg 0mTxw3AIFh1yk8DeGQ/X8JLG78Q3aC6clrGon+N2JYsyXwfv3uP07x7Puf83 97p/Ctxh9Bud/rD/F4eFR8TwWHZx5F2AiR+YYapTlkaZQhSGshTgRI1XCnia jkcaeWfqOTSnS8kc2KHLAOuhLeXdcNvx5rXdDeYi01AFTco3ROq2/tjtGoQc XgYRNHIOku2mdvDWRktYozgMnCpZGQbFMiPzAAMV34hOK0EUu+2Nc0IqWRME AC8RQKTsyJKJNIQqizpn885TCsu6fkT7Vf10HaeRvjb1C4CkzD+R3CBj3gmn ccKtYkUT+LTsx+aSfTdrORnjyu31R8yQHw1pDYAYYyBBtDbQYV3xQ0Nqlx85 cdQfsX1Nte1th4IFT1UizpQBOoGGXRgJjaexaSeInVWzLNchqQZD4qHfj+2d dXy43abMJquwkkkuPaZ8xIO6cATB6UcOTn+VYVkuxL5KJBuTzhW/COiEQWHo LR9usql9THQlb9OkzrDOYM4yHVX06IHzHEG0dxAT2OT1r0cOOFzQdLYfp/eb u20lO1qhZSl8xJkgnIyD+IUC1JzXP5lxtJpXiweLhWEBjNyQC1ODIupuGr2S vAywzzTfKtrxcyVzIbyFdYHzS+awygBHLEbwrQgvbw8qFgOwsE1ogYJ6XiaU CEgix4sXt2uWaTjPdaph7z6qubyKtV2gTT7CDgWxpkgGWBfQLlz6bbOyeg8X WllyKNpUFeEcZ9hqMdmbWoV5pT88iVv9cnY4PhC7Px/s7ouj009P40qbIfm1 TIJEwUhzXq8gy5lGk6W3l/FCJj0hc8jiSrENaBCtcXKntC0MKC0pnCOcBYwI 3Ur4LYu/2VjDJsMI7XUauxlQtMjKrTnYWO3Fs6+AEHr3BEf7lDlbwMcGrGg8 d4K1tGBiAaNfzHUEtjxHntyfb/DRlAYUVtAY9eupfyWe+wGxkqM4LW9eNKhW OvG0eTUFBFDO5ivjMHlnWiaJtR9Marz0O3QDofmKgHKS8MCIbRJBlDZhZaxw akjkPAWZ6Vfb5AJg/4ECYA3YlBLGaEGxNfSBBrjb3tRGq2VxNzp2+1dsc84D OPs0ZIANT4g4whtq18vEk4RVHeFeo6MdyjmHuQovMx3TtRkORFg9IpqZ2ds0 ynlYR5jomXWQrqlnQUWPYYhQMpw3GdSR8o6LlO3wr4amP2pRuss3Dq9lPlMM 9gc7lCupiIRriVzWsyfIQPbFaDDEemte1zLnG6MPNI4NDrxlc7aSjzORcHRv D3ew0JHywbsLto07+URa8B1NBAiy8egue5Yu4V25af/scCD+cpR0E9mWrBsk SwBE5jqJoF7vxBaleDIJUAf8y9Q1iw1/FJq/rSmdbyLk6JNiTEdH10eiC6Uv xPeiPxUvF2nx0oavLx1HuN+XYPCXv4gwo6HvJenWK653nJ0YG7rbixPmOi7o Zm1KXpguO92s0nIxIVc3rcLF1uY9SRz3+ehJU8HnAP6kP+csuOfmBSsd+SB3 baLtLelCGhIGqQfde6ZL4bwMWmUBcJwkEApfL1Ka3tp+MqODDc66sl1HuzVd r9lwAX7UEgWBbReVG39Uk4kpheFNUzB6c68tqIxAa9vqmTXUYxtHs2PNVm3t 3t86qsdWKlZ4wl9BcQrR+XC+6Z+lOrcWWVZi83fWbWfqWm1Wxx7MzkoXYyUO KV3FkWJ/S0LfeCQBn1XbElS5x471NY4/Nv89Z94/cN7dA1h4QIgmTJRMyywg d0Snp3kYbiRlNjBBeyHtSMlHs1dQDgOeu2Wcu2WsJS6nd5W0Gvim9pybOt30 JvFrqTj2gBkmvXZOdQ0w5AJTFr+3F96rvWJ1IIW1byYKpkPRTXWoyIH5Uf0o XFxAxQfU9mX3yMrZca3AEPy1mzRCSzUFnCuUHaA1GVOAExzU7M+ZTsWOJrbO XOiAuOqInCZVlK2E2ognU599umAtAPuwcbZQRMOMVuiscYIaWxlMlYomCIBq GKm4YGWqWypKDiWjMhHngUBIS13yfSP0uzDt2bYPNGFIuvnn8+NpYHgo0IYA m3dYZVrdj9LwVgsbEff9ZuEJnMAvFwdnv4nxxcnhyROFHJ8TithycWxB917r 9pajtJSWF0ziYiEziu9cFtq9n0tAzdns9st/6niFlNTr5jYHfk0A4HbTAoYs j1nXmm8V0NZt9imOc6J11n5r1NfbfI29N2y8KeKoJmsJhlIUJBbSQwtEO+Bp cTxF+HQOBhb7LqD5pbdf+JNDaLmEjoI1FaYBY0Z60er62nU1hIKYjOtsJrBc gI5ZGRQl4KenBqwcPUzOwrzVabjzYCcbJum82WP7/i513B7Co0Ka8TfFQYkV 3CeVAi+H4hc+nqeI0BYgsD5ypr5qJ3j6Z4BwSRlCkZwsdi/B3+7PamDg2jOt Ez+ok55LsfuQrQqDLCvXb4aJWcU2v7OnpSIHOomlqVMhbmqDnf72YFjRqsjK sBkPDRARDVxcc8qFHl6/TjM7IxKPmwWbWnjvODR10EEJnHaURMEF6WVO+ddA 3YRJaewtEYeQxJbiboQjHHsjzK7eo2eZ4xQ4TZnmLjVN8x7dnnaHTCG0I0lg AuqE5Q8bHTqGdzRw1FinbRwBeR49rco5vFH92+nhCaCDLM0TWdGDs7PTMwLU p2djGFIutjg6/fTpyYzqFy4Hgsc60jaUo/K3CPYpTqWTc9cUwJ22DuhXmcSR r1oiHAQ/NHGk5ESr/AZ36YnQXIFhj5Ia/DdBc/aM9FRXWWQO4GM8RGsFFbQO hOvsqSowhHczAhq0VXzV7+JKKg71tZX4Q+WsFlS4DnwBwfN6x8tcYVKFrQds ZwFUssLCMwqluB9Pvz0r6LOmAThCNANxZmcZVXNqOW3uagZr3alb0ClzG3La 5cTTO1ZP6CV953auWcKVzQK8432r39vC3WrGPIDLq1Yb4oob5cTopATE0lR5 in2JbcmoLTWzAxKT1VvZr0l/67f+1qK/FQVbP28db50PeB6dalgbSiMKp/Kn 1rBxCttAEUORTwkHPX8hFKx6RpklP55PM1BdvO0IsMjKyg10vVCtr2K+RkUG D1DkZQpUpQKY0Ny11LpxOGUrxWVZZPagHdWafNVndQZojbxQaROBqbpuUiMY nVTEfljgU8lGF/gvpYCIgj7SpkppPlK1c4kQxnWxWU9oiA7JUoo6yUjy67sa Qr+UHl/K6dSrWgW/ITRyVKv0OIb7VTqzlSAFhOAUkZ0jibQSCUu+AUQB2gVd yNMFHcnYM3eB2ihiwt2y0IBR8MeV3PXUR8iGBeZ5znnQKvcBpExrxVxrkLs6 lPPCo6G96vuXBluQ+GknAduzshjcjhsG7ROM06OuAMpu2yO2i+8ovjas3jKM k5hvbLpUhHo07FZttmixWf3QNHesAveO422ueH4dp6+2X2BEfhW4CzdwrSvu u5VrSJueIUyoBj5AVAZca4y7rYE6xaGi1TuvEFMGPrJBd6Sqi2lbUNFIa0dq Us52Vp5frzy/WnneXnke1c8NoyzcrBr3ojafWb+ANYddtjqysiJH+z9gSRRa /u413S2QqYSpa1wi4+yGjeVzVwZzamG1jN/8nxeBeF6FCGRBp9MXDaH4JHlL Lv2RTURQ4sge9qiHg09+ne1cRVsZQM5Wz1WcV1l30xM/+j5VPtnm0Fzf6pON dpbCprNqM7xyz+GOrSyax5YlGmQ5IW+gauNrsFoNuXIY4K5GQLJb71VRLG2z C5L4s4nGNYijX/maovka4ruvxUf1jXdWQ69UPtHGGkgXgrCnU1hXz7/hAMJS KuEPtuVC5bsOrlScqZSeVjSNb+pyN5OpkMJ5q/4NBd+SlHqsE5WtIkk0l2im orPV9xRpUaqZwrbVNgKf9qKRa+BZY+h6sEEyb5M0Wvg+w9VFHO43GmhnyC1C qxYZoxPKMrU0piZe3CK+jzIGZXUJIxvna4ukSt+6sBo33tPlra8Pac0waTTw Zzpt/QaFaVC4L4L8JBtUV6C6ivOixIY1y5dag9HmthvF8yEhaiqJadyYbn2l MQud2S8lYPhA4OtbajL+tW8BbPctUqKtrn9jL4n+Y6vc2tqKfhRdp3M6vAxs Us/Xulp0zGVWtuFHUnEZManLEdrOTXPUpdlblaV/4QxESY9wcM/mxxnS+vqd xoUsjUXvNWd9bCOiEAiQ0DNF8tU2MBLlkkA6E9OYbt0JTFFNj/9oqZmi9Rio ZRaruiCzwVPCer5RKRJW8DcJU9x9mpupi5Px4fGBOB/vjg/Px4d7T/JBT98m kF4eUkaLbhBcRkTsVTEal1HlVFDG9WxxEbtLdf+aqzPbr2JNYrK3sGys7Osp UL+3mLTljb3PErfrraGWAaefawS8/Vo8GHx2yiyiCMhpN2ZRcM0rTY10z1iN Wo01qSmg6vyN6irFC+JYpzHV5Kd1joFdkYUcLduf2WTT7QZ1o8Ky0He0VOeh 1fQU+rR7MT79dXfv4uJYfN492z0+GB+cPYVKSSzU3mzV90cuLdFoMuXEbdFf hejqtLI51Za2dIvuud1nkvwdLYmu5tZCPA2cc+dp9hWb8AG1lVgH4fiOfwDe DJpiCeqKqqq0on1Ve6ec1vompDFKKjO+jKk/U+BHX8nWGAMLMq2u7q9m2niH 0qJU61HPMtfXwp424y7I/ARt/xZLmcpk+U39cZ6OwV3z5Mw5hZ82FTYcbH9H F6/OV9L3iax9bEPcTd4DM7zFbfQot7vmNs2V+qZ4r22mYNv/lxd2u+MFJP8P OHJqdXxcXZib3O/a7bvKOLepsKj6RMax5Vpqd63ZSO/VrHq3rt8a/pESJ5ye FLcGvHc6jcLbuydjCe6ZTHPQtn41uD/Nh4NHhwcn48b3g8J9pfNEjvi8gkat +k2j6Fo74LIfOKvNfyOEvtnLyglgPCdIDWKXhbT/S0F9u8Fq6j9csfVHUjRe EnkPDSRY06z9c0XTNamvM2YOvt5hhZOpWFUmkJI6frtraleqVUGBYKKjGlBU k6/BbhAbnVT5fP4PB2xxW6Gi7t09iCjg8avI7zYRl13kfJYdlcPJQaPCJsi1 /Y4HAGAWp10LIqzDbtU6fXfr1pqcTiPQJp9Vg+G1O61Yk9jnHXecMVmlYEH7 3GRNREBXBjblR8uZqxu7ofhHz2WpNzo3i4QuRCwqomDvzesuv9X+w6guZolI u3BptiNtLy0RTv2k84W0//cEtJYteLG0ssMG9sRyQbvlyxqqtjofeAes7vh3 gZxMcnUVV9eKXZfY7XIoQ+VUBFbdf5Bg63GuZJzYbzfI7X3zhXukxE1m9L+G cEV0kSx7xCDntGcdFLmR6he7JV0GJrGsXwE914+/6ZKvAzizr+hTELi269R9 Ql2X0VLt6Eu/QqorfWm/qs5lME20pK9HZzbIcvfe0JX+aKfHYOFVldNUaagj i7TN1ySQJoxjB1cQEtGimt9I+jC+CvFc7/tKhYB9Y6z1m632pcdo0hP/3d61 NbVtBeG+Vr9CE5dxSsGxDYQ0GabjgANuATPEYZq+eBTZBqWO7Up2g1/623u+ 3XORhDE0WMkkXT0lRueic9nds2f3+97NaKznOSiJijcM097I8vug++tZZTYd PCvrkxutF9xy6Bwtco0YR4fzJcHcTqg2NTZTvSKX1GZfG9hliNLKsOjHUXhH YW1+ZItq2ylXLluQ3kkV85x+y+Xn42U1tT4Lc8/KI/VbVwt4LqHPIyH8fePL ShIhLracvtE+MLNJDjKdyMMpIXOrJX5QP6gzDp3YQ+ToL0wdKURtHrf3f/NP GqeNw+aJ0p8F6Mq8ZwGiLuFEhYVZXervT7fNDqpV72FYmeS0ZkCXJeGfxugb jqesL/+p796Wi7ZhvKZakpRuzzfz1/3H+VT3n27PMkPPcr3B0UK/31v29ff/ +CLWxIU6aioD6snZcaPzqn1+ooyqk7NGp/WyddzqvC0o5AoyHtkwKTimC3Xk smEggdL+cyUihkNjfSBALhkGyVX3rxm8lUqiBoO+lbDfZ8M8Mn9zNgb8j91x 1LPHfNauXRZqqeh09jxT6LsS9pM4+lspCBacVI760FUinG/P4L2y6cAliPpo pNZYNEVQovNwjHpBTIgFkEtoUAtT84bNHrFBW0kqHMsGzVAcAyc475OeSYwf aJTgTzRuXfK6Fem04JiSo8bpwXExYST962iK63LWQ86fOQU0wgj627hwdVQ2 vfiLV9L7pUtXq90wVqvGN7GVcd/pTX33iqWFq2Z68ZeigE5etQ4ZBKh1un/8 5qBZFAZQYlCpEg5qdUYDh45A1yh5SKGd7J8du8AAhusyijIPQejBSKQ4Cjjp tMk5qPTK2lzmEAvt9OXIGyXYygyPQy3a0Bzr4zNVuKqjQZdu/EkP8r8cwE6q DT7FRANgpvFrtg6KLuKbFl00V7aYSX7zutM+af3RPPDbZ4XBPDV6PTelMF4A 9jNi0Qm95n1p9EJ5HvoQ/qcJ3i8E/VPjf+ZwPx3+Z61Wr6XwP5/uflet7ezu CP7nZ3nuwO/MI4CalaIPNvfCANUooE0GdTSokZRhwKk1OK6ncAkpPinVJoAo E4ZRVDYtrA6O9+aUOdsjHPbtuZYsM9wWhFOGUkw5czyb6cNQhq2B/yizAwho 1OBtLgDzBDyO1Sob0AkRcAANCCZUmUmnYSDMiu83SP0nsxA+/MFsaPutywNn Rw0AIEVVt11/kGn4iMKfRoh211lgyEBkaIowJKsQJ3xVxSbw8QCAdXN0Ypvb gQjDPIbnpwGzLsNZ9culcgbpNIuqql1JNyBVFwGqeqV7QaquSvPxom+c7x+1 Lpr+eXO/fYG8kIJuy2iIYEWOY5spSr+Zq2qNZXPVRwSiCVrAKlBzxxeKHKob jidzFzSqKqA8n1RCVIDInnEcXKagbqk2PhoQhi78eoEa7LUBQEU5z4wWJ2Wg 2lRvTiMdaHdxQtHCpmk+965NllZg43LJU2F6j7/Y6FLEi9pF6qBS1X/W9Wm1 t87gdTeFAbumDFawV2JXk03ISgkDLQJoNCPEEiDxRMdjpoYo7iNl38K74Ljg c4oWxUcH0VBtzkoK1heF1hGCuU5hyAlgYzNRvdwGNg72cVbauA38AtLhg9JR +R5QdGQy5pr5I07bnabrOaSgmaa1iYnVVXILOepoilbG2uCFFiWqgv71RHtP P2gDnvy07CKAq4Haya1Ve6vAUSLhkgRh1Y8yanCfZ9MdFy98NbNmDvMbYGzW Pu5f+yTi9FGMgrcqZuFoOTJL+hC6mAFqEqtgNuGlqNcO6Y981mgplcWd7Sp7 znjz8qLrqnPIAz/E5b/TLahRAvf7GBPd28+LEz1tN3tpv2Gl8syJzE7j/LDZ KVRyvpy7kDmr7Gixx+PhUA3RxyDuGVRAnLy11EKyKDyrrP+BJv0xYHRsiptK F8Y2NXMZ+rS8NjSyE+1M3DQErnHOIeItiTsAiNWFr/j9iE7DEInOT9fqbeAX upbzKKYdfzcRY8jO0JWgXl2DOW7SCY3/yVIkVS9Szi2oc74npHT9x5ES3vT5 XK+q4D0+kBeWqpz+py+pUQ1DVXMdGH4MEseh/ljhjW5XHb+UQm00AqOnZOec dJVawnV1Gtis1jbrT8uLShtnvCtdr1a3N6u7m7Vtv15/vvXz82rVb77uLCx9 HdkFn/8TDWACKYAAO7Zubq4MAxxCCTMBTQojc2ecGsDhizgY8JGFcoftSlGk ykYabujVxArPVqPvH3CwJvOV4XPLQ7pDK6MDqqse47Pwj/47Nb9KwUISsKol d3MZBq+SF+T0gLKpLPhk2+yebcJ99QTpYd0AQbWZUmRzjHTEcHa7URFSS7qL +TXGMPHhFRD6O2TxowDdo3INGJ1oNANi+DQa8ohdUwIEjIc5cFhnlE1DknA4 5IrUfwzY/VWQEFoxhUP70cADHvPUynSDb2z6j7wjhE4u6mmid/CtA+HWyUol GsL8Tg9evvVfN8+VCC1UdJqccJwH6AfKlkj/mpnunP2twVtp5hDFRMes1NEK NlV6WsezRO1zhIVabP6g14u0Uvz9uH1I8xDj8nuWkCs9r8dgWD5BYmUcfcAt F65LEFyPmcp0m33cWEG5N836JmDrJR80jedslNJ9jFEfujbuHuOVZKGG2Y5m e5Gy3jPflRkJ9DnfO7qRVx3aszDNFEK9t7O9VXci79Y39PZNa8S8QeMDxSPR 44q+ZvpnQNrdwKVACoaY0gWakg4nqZPlho/3kyuHCMHpA4BmSqNyRoyU8ISl HJc0YtEcCpSMjaPLS1zKshQjwZGeqMkYswUpmnqRy0/6cTTuRSEdjfmYg+Br vUzNB5rKsPSjaTnhEyftfV2lA5Fd/W4/anfsji9yqx8puWdgQSgNUp1GUh4X nEIIY5y4S3Ku+FV/tZOkSgNxzNjelg5Q+dLesP/fs5D/ib1XK2vjLv6nWnXb +X+3tsD/tL2zLf7fz/EI/5PwPwn/ky/8T8L/ZDot/E/LG/CE/0n4n4T/aXmD 3rfH/1TSBFBwNtz1rhBACQGUEEAJAZQQQAkBlBBArag1TwighABKCKCEAEoI oIQASgigHtKCJwRQQgAlBFBLCKBKD2aAKt2fAqokHFDCASUcUF8dB1T92a3i QEigvjkSKJ0TLyxQwgIlLFCfVr0nLFDCAiUsUMICJSxQq2vNExYoYYESFihh gWLPp7BACQuUsED5wgIlLFDCAiUsUMICJSxQwgJFm0tYoJY04gkLlC8sUCtt R1igFpk3wgIlLFDCAiUsULc1ZnWOsEAJC5SwQAkLlLBACQuUsEAtbEFYoIQF 6o4GPWGBEhao+zQgLFD/tRlPWKCEBUpYoOSRRx555JFHHnm+pudf0bTPKQDI AAA= --------------090703080008050504050803 Content-Type: text/plain Content-Disposition: inline Content-Transfer-Encoding: 8bit MIME-Version: 1.0 -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers --------------090703080008050504050803--