From Josef.Springer@joops.com Thu Sep 20 15:51:47 2007 Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 5328E9F9A46 for ; Thu, 20 Sep 2007 12:51:47 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 17895-02 for ; Thu, 20 Sep 2007 12:51:28 -0300 (ADT) Received: from mx1.hub.org (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 9C3BA9F9AAB for ; Thu, 20 Sep 2007 12:51:28 -0300 (ADT) X-Greylist: delayed 00:07:21.928491 by SQLgrey-1.7.5 Received: from vserver0202.onit4u.de (ns3.onit4u.de [213.133.112.5]) by mx1.hub.org (Postfix) with ESMTP id 83D15606D61 for ; Thu, 20 Sep 2007 12:51:27 -0300 (ADT) Received: from joops.com (dslb-088-064-015-247.pools.arcor-ip.net [88.64.15.247]) by vserver0202.onit4u.de (8.11.6/8.11.6/SuSE Linux 0.5) with ESMTP id l8KFhxe11255 for ; Thu, 20 Sep 2007 17:44:00 +0200 Message-ID: <46F294F1.50004@joops.com> Date: Thu, 20 Sep 2007 17:42:41 +0200 From: Josef Springer User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:0.9.4) Gecko/20011128 Netscape6/6.2.1 X-Accept-Language: en-us, de-de MIME-Version: 1.0 To: pgsql-admin@postgresql.org Subject: How to update from 8.1 to 8.2 ? Content-Type: multipart/alternative; boundary="------------070705000607040305060607" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=1.353 tagged_above=0 required=5 tests=AWL=-0.427, BAYES_50=0.001, HTML_IMAGE_ONLY_32=1.778, HTML_MESSAGE=0.001 X-Spam-Level: * X-Archive-Number: 200709/123 X-Sequence-Number: 26884 --------------070705000607040305060607 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: quoted-printable Where is the documentation of the steps dto do for updating e.g. from=20 8.1 to 8.2 ? I have never done this and could not find any docs for. mit freundlichen Gr=FC=DFen / best regards, Josef Springer (Gesch=E4ftsleitung/Management) [Postal] Address Josef.Springer@joops.com Orlando-di-Lasso Str. 2 D-85640 Putzbrunn [Phone] Office +49 (0)89 600 6920 [Phone] Fax +49 (0)89 600 69220 [Web] Web http://www.joops.com [JOOPS] (HRB M=FCnchen 86239) -- the software company -- =20 --------------070705000607040305060607 Content-Type: multipart/related; boundary="------------070203010502000309060005" --------------070203010502000309060005 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit Where is the documentation of the steps dto do for updating e.g. from 8.1 to 8.2 ?
I have never done this and could not find any docs for.

Signature mit freundlichen Grüßen / best regards,
Josef Springer
(Geschäftsleitung/Management)

Postal
Address
Josef.Springer@joops.com
Orlando-di-Lasso Str. 2
D-85640 Putzbrunn
Phone
Office
+49 (0)89 600 6920


Phone
Fax
+49 (0)89 600 69220


Web
Web
http://www.joops.com



JOOPS
(HRB München 86239)

-- the software company --

 
--------------070203010502000309060005 Content-Type: image/jpeg; name="Postal.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="Postal.jpg" /9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcHBw8LCwkMEQ8S EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcGBw4ICA4eFBEU Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh7/wAAR CAAQABEDASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD6y1zXtP0iM/aZFEuAViwc8kgE4BwvB59j 16VjaZ4202TxXa+HZtRsrm6vojJbtbBlJK+ZuQqSTjETkPnB2MMAgbqvj+x1m51GZLDSNSu7 ae1jjke0nt4+Q0uVYSyKejgggfjWd4B8DazZSaPearqYii06/u7yCwaDfMnneeqq8/mNuwk3 596AR6Xx6CilooA//9k= --------------070203010502000309060005 Content-Type: image/jpeg; name="Phone.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="Phone.jpg" /9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcHBw8LCwkMEQ8S EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcGBw4ICA4eFBEU Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh7/wAAR CAAPAA0DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1z4o/HW58FfEibwjL4OnS1Sxe6j1jUnuo ba6aONZZlgFvaztIscbBnf5Qu2QHGAW7P4HePbj4keAoPE194V1Lw1LLKVW2vQSJY9quk0Ll V8yJldcNtAyGAyBuOL8UvgloHxC8Y2/iy78TeLNFv4LGGyVtGvkt1KRzm4jJzGzbhIVcc4BR CACua634W+DNJ+HngXT/AAbo1xe3Fhpxl8qS8kVpT5kjSncVVR1c4wBxigD/2Q== --------------070203010502000309060005 Content-Type: image/jpeg; name="Phone.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="Phone.jpg" /9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcHBw8LCwkMEQ8S EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcGBw4ICA4eFBEU Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh7/wAAR CAAPAA0DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD1z4o/HW58FfEibwjL4OnS1Sxe6j1jUnuo ba6aONZZlgFvaztIscbBnf5Qu2QHGAW7P4HePbj4keAoPE194V1Lw1LLKVW2vQSJY9quk0Ll V8yJldcNtAyGAyBuOL8UvgloHxC8Y2/iy78TeLNFv4LGGyVtGvkt1KRzm4jJzGzbhIVcc4BR CACua634W+DNJ+HngXT/AAbo1xe3Fhpxl8qS8kVpT5kjSncVVR1c4wBxigD/2Q== --------------070203010502000309060005 Content-Type: image/jpeg; name="Web.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="Web.jpg" /9j/4AAQSkZJRgABAQEBLAEsAAD/2wBDAAUDBAQEAwUEBAQFBQUGBwwIBwcHBw8LCwkMEQ8S EhEPERETFhwXExQaFRERGCEYGh0dHx8fExciJCIeJBweHx7/2wBDAQUFBQcGBw4ICA4eFBEU Hh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh4eHh7/wAAR CAAPAA8DASIAAhEBAxEB/8QAHwAAAQUBAQEBAQEAAAAAAAAAAAECAwQFBgcICQoL/8QAtRAA AgEDAwIEAwUFBAQAAAF9AQIDAAQRBRIhMUEGE1FhByJxFDKBkaEII0KxwRVS0fAkM2JyggkK FhcYGRolJicoKSo0NTY3ODk6Q0RFRkdISUpTVFVWV1hZWmNkZWZnaGlqc3R1dnd4eXqDhIWG h4iJipKTlJWWl5iZmqKjpKWmp6ipqrKztLW2t7i5usLDxMXGx8jJytLT1NXW19jZ2uHi4+Tl 5ufo6erx8vP09fb3+Pn6/8QAHwEAAwEBAQEBAQEBAQAAAAAAAAECAwQFBgcICQoL/8QAtREA AgECBAQDBAcFBAQAAQJ3AAECAxEEBSExBhJBUQdhcRMiMoEIFEKRobHBCSMzUvAVYnLRChYk NOEl8RcYGRomJygpKjU2Nzg5OkNERUZHSElKU1RVVldYWVpjZGVmZ2hpanN0dXZ3eHl6goOE hYaHiImKkpOUlZaXmJmaoqOkpaanqKmqsrO0tba3uLm6wsPExcbHyMnK0tPU1dbX2Nna4uPk 5ebn6Onq8vP09fb3+Pn6/9oADAMBAAIRAxEAPwD2z4nfGe38MeKLjwxpVol/qtpFG81uIpJJ ZJJFLRxRRqPmO0bmYkBVIwGJwOi+CvxCX4ieE31N9PfT7+0uGtL62YHCSqATtJAOMMOCMg5H bJ434rfBubxL8QbTx54X1mfQNdhXy7mRrdJ4bhQpQNsLjB25U5zkY4BGa6f4J+DdV8FafrVl q11BfS3+pPfG9SLynnZ0QMXUMQpypAC8bQPXA3xHsVGn7J6219TGEKrnJya5VsurP//Z --------------070203010502000309060005 Content-Type: image/jpeg; name="Image120.jpg" Content-Transfer-Encoding: base64 Content-ID: Content-Disposition: inline; filename="Image120.jpg" /9j/4AAQSkZJRgABAQEAxgDGAAD/2wBDAAEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEB AQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/2wBDAQEBAQEBAQEBAQEBAQEB AQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQEBAQH/wAAR CAA9ANwDASIAAhEBAxEB/8QAHQAAAwADAQEBAQAAAAAAAAAAAAgJBgcKBQQDAv/EADgQAAEE AgECAgcIAgICAwEAAAUDBAYHAggJAAFY2RIWGBl4mJkKERMUFTm31iK5NjcXISQydrb/xAAU AQEAAAAAAAAAAAAAAAAAAAAA/8QAFBEBAAAAAAAAAAAAAAAAAAAAAP/aAAwDAQACEQMRAD8A fTQTQTRKZaJaVS+X6ValSqWSrUrXGSSiUSTXGnTkikkiOU7DSZs8fNk4a6JGDRgk6ckShQi5 cPiD5wu7drrOFlFMm193Bx4eAzTD5XKP/o3Rxwft4aF/Bhq5/B8G6c/oEw93Bx4eAzTD5XKP /o3R7uDjw8BmmHyuUf8A0bqaXPwzs2kNOJvthQF/7C0xZ8VnVZtS6UHvSzhkKOx+QlBkBXGp 12rIXsKArJZPBZXu6igaNLvX7YgSLLkn5J7m7b/iXh551pXrleNhW9eVyWtc1NRibzKTWxcF gzQf2cTJBpJO40HCSshWggFEJ2zQFjyoyNN5GuxRVwIGXfZ67wUDd3u4OPDwGaYfK5R/9G6U qG6CaJOt7djog50q1KcRMHqVpVJAkXX1xp1aOh5FKri37GSg8LCKQ3IaPNSQbDYgOPlGjZF8 YYxWNtCK7huDGJtbCdJhBv3D9o/gw0L/AJw5H+gPdwceHgM0w+Vyj/6N0e7g48PAZph8rlH/ ANG6ZC1bQg1J1rOrdsw+0i9f1xFjMxlx9737/gjgYJks/eq4JYdu6zt2omj+XHj2uCr0k/Wb D2KC7xygjnBvTmz9peZgnOthZJaFo6laAx6YmoNStQ0XKHNdXVd5CPZt0yk3tK6gaXaXBY22 /NKjVIzWRwAxcHe70EoTc5QpzIZiFVPdwceHgM0w+Vyj/wCjdHu4OPDwGaYfK5R/9G6VK5uN ewoLDzE10D2x2jpO9o2N7lYjGLH2Dsm/aLsYyMao5Yxyx4JfZ+xWSKUl7tVGOElEOR6sbdlF CKbF6Oa4CO3ocTHJ8I5E6ulguZxdKsdn6MfsotfVY9uzhuzRKqKPh6MvijUgqqTQjpYmHLMX oQgq6Kw42zXBlHj9uoGNmg8ffvQTRKG6Jbqy+IaValRWWRXUrY6SReURvXGnQcijciB07MiY Q8BNjIa1JBzQck1bERZQc5bvh75ug7aLouEU1MW193Bx4eAzTD5XKP8A6N0cj/7eG+nwYbR/ wfOenP6BMPdwceHgM0w+Vyj/AOjdHu4OPDwGaYfK5R/9G6ULlV5OSumS1Ra6a+xQVaG7W0Js PF6WhJnNTONRZtI5EhEBs7mrdq5avXbR/I11AsVDpuWLcuRHnH78kgNjT5mRzeBcZz+VRNgX 3K2v2t2Cu0sx/OSw3Ddi7eoKqY0ff9k1yDGqqro+S1rFwoAct6bJg6NCCJUq3TwdkU2mHdmJ Fgw3u4OPDwGaYfK5R/8ARuj3cHHh4DNMPlco/wDo3UhdmtgtlOEm2Kjmk/t+29vuOO6JUrAJ NjcpNKdbBa7TlduuYbOA9qLs2RyxQpIGyLlwIGYuyDx6wisgBZPhJbswkpnoqikpjs5i8bm0 QMMJFE5gADymLyAWvi5GHY7IBzYsEMDnOP8Ai4YExrts9aL4/wCKrddNTt/6y7dBJqG6CaJO t7djog50q1KcRMHqVpVJAkXX1xp1aOh5FKri37GSg8LCKQ3IaPNSQbDYgOPlGjZF8YYxWNtC K7huDGJtW193Bx4eAzTD5XKP/o3RBv3D9o/gw0L/AJw5H+nP6BMPdwceHgM0w+Vyj/6N0e7g 48PAZph8rlH/ANG658ftBEhvjT2W6jSPWXa3aeqRl7zKwonYUXZbBWtJA2boY+gDsUcjqcxl UgXjyqSUoONXIlg4wAdkcBGA4UOwZr4u3r240g3Q1s1+sO8tNOSndaU2nUMVM2IvAdkpXW95 RKxgsOHOzJuPjxr+rBOAeSOwyBDuJ7ZNSwowTQGilRwxVz+uswpH7uDjw8BmmHyuUf8A0bpS t1dBNEorTsNJxfSrUqNknW2ugkbckQOuNOh3ziOzLe3XGIS8Cu7HQ1u4WCyqJnDcXkgtRTJi cjpgoEJoOhpB22W/jhe5NCHJXredk87joyMXbT8gHwu1GsfwURjMgzKjcyUZm8fYruHboQ1k TVqSavwrhy57MTQUnmyX7jHLFFBuN9P+j4N8Z/HB/sP1c6A93Bx4eAzTD5XKP/o3R7uDjw8B mmHyuUf/AEbpz+p/coO5jvQnSi39jggcbIZrH24OM12DMZqYiHs6mpxjHAboskgq3cPBUf7P nUoKDWrlo5Kjgboa3esFXeL1uGZe7g48PAZph8rlH/0bo93Bx4eAzTD5XKP/AKN0kOtHH2Qv ShaqvfY7dDcyyL4t+vojaj2eVhs7YdRwWCvJ7Hh8nbBqfr+sSgCuxsYCIk0W7Fd/HC6R7NFQ m4aoMnyYdp4uo8S3Wpjk+nVE7FbKzfY+iwumxiY62yiXC4uDNKCylx14HkrKxfVEKCazGzow sMYi3swMJP3j2PvxhQf3C5yU4GSB+PdwceHgM0w+Vyj/AOjdN5w81vXdR5cj9e1RAoXWMAj+ /wCF/QYPXsWBwuHhP1bjq4+ThT9IjMbYjQo39SNEiJch+SZI/nChB6QcfiO3S6ynp9ZDxd/8 x5N/j/iv+tbjr6BD+OD9vDQv4MNXP4Pg3Tn9Jhxwft4aF/Bhq5/B8G6bg+fCRQCblEmLDwMc jYgkfkB0s7RYCgoQOzWIlSxN85zTbsh45g2cPHrtdTBFu2RVWVzxwwyy7BEX7R3+05en/wCz pH+XIj05/FJ+2ro18MdR/wD8iO6mjznX/S2yHC7b1p0XZcTs+vzdhVCKGyaKk03jJUqJt+LJ kxKyWfZF4xKseyOazgY+bNnybXuk87t/yi6KylYuOaCSCstBtNIHLGLoVKI1rPS7GRiHzfu1 fBTmcBBuioN8h3UU/DehXzhcW7/z79snDRTPtjh2y7YYg53SYQb9w/aP4MNC/wCcOR/pz+kw g37h+0fwYaF/zhyP9BLr7TdOJFEeMQmFBuXDZjZN7VRB5V2b+l27OI63Tk8+xbOM8Vku+DdS QwaP5Z/4uMVMsMEc0fQVyWRcbhLBjI9xWaXMBLbBq1cVe9OKpJ44Y45k5PNpVJTTnv2wxwx7 5vDBZ+8Uy79u+eai+eamWamWWeWRcumnJfebQy56RiCKC1ltmoqxapScZ4JJvJ9AXuJpiBxV VURboLTEPibhLZ47WSZj3EjSIus8UGinfpMvs6eyg2ztER2uMkVXDXhp5K5VVVjQc4muwlQo G+lchOwsmQDPE0nQ9q3SdFoFm3Wx7OGpmBFkHaLbLJviqF+euJzRN+5qj7T1tNBoYrmOjdmS fZhhKh2P4eKDtsZD4XS6SxSRTSRwwSnAVk8afcn+Ig3w7o91FO+auavZ5NZpE64iEnn87kAu KQuGAiknlUlNOsGYkEACs1iBQoQcqf4otWTNBVdXL7ssu+OHo4Y555Y49+VLg1oeXbOb3bj8 u0wAEAdZWVN7ZjmuKRtDJJ6fRmM0yyJn2WK+X5rsygkIDDoB3f4p4sCZc7IWDPLBaNvmyIdA vI/+3hvp8GG0f8Hznpz+kw5H/wBvDfT4MNo/4PnPTn9BxQuDD62PtaAATOO+JQXBJETDxMau mnm1DMa+0ukk0jnZompk59DLCYpryvJTvn+JiXIOnKGLLv8AgoNu17rjr5WawO8e/MZq5yuJ iiS2v1izWEx655IIav1cYRJkIS4p+bNnyA/BfLHGS0r6Uij7dLDDOTmAcyHqN+6yeTh/2AhD YeShREjjpUedj58WwNgjYh43ICjAcq0SfjCox+0UVavh5Bkug7ZPGyqjdy2WSWRUzTzxy7hF T7RZGBB/iS2NKkkPxnsJkNFyePqfcl3/ACpd3eleQxZf71ElM8fSAy421+9HJFX/AOT93dXu j3VRV9r7PjNpBN+J7WhaRvcyLqMLWlCR7xbv3yX7x+M2vM2MdZK9/wD1j6AYN+SBsu2GOHbE cNZ45+mtiqqouX2jy5nBDVyA6JVc1cTjYfci1q9BxqrY/wBsXclIQqISlrK8zWTXHLti0aOr AAQ0IwcEc2jNz6Rt7g67No4WUbVm49tV0dKdM6B1o/NtSJet4X6MvJsu+ebIjPpUWJTSfO2C quOK6wvOYyI0mHzXxxW7CE2KeaaXodksA/ODfuH7R/BhoX/OHI/05/SYQb9w/aP4MNC/5w5H +nP6Dkk+1RL4tm3HY5yTXVxb3DaC+STZFRy5UxSTqVTum3bo45qrr59sfRSRSxyUVU744YY5 ZZdu3el28/JFg515tCrdX9adx7p2Os2FSCuovA1tNNnYGwhRSagVRGUrnZqx6piYXuEjTIsq ZySAvzKBdVkggq+GAnyklZzV+1Nqpp+7k/EUww+65bNV7+nnjj9yaf8A4i/EU7+l37fdgn6e Pp5//XD0sfS79vv7ff1r9BCLgL44rO4/dZJs7vVBuGui/JYHl0lhTMi1KJwKMRkS4GRCMlXo 9w8FO5R+KVkRk6sJduWLZMsND9l1nQlysrQ7fT/o+DfGfxwf7D9XOnP6TDfT/o+DfGfxwf7D 9XOgc/pTt4tSITvNq7a2sc8IugQuxRDLsKlDBtg8fxGWx4sxkkRk7Zpku0/PYCZCKYLERfZ4 x7Gg/ciFUetUSKq2DY9JLv8AbT9tNKGE3w+XYNYqEu/X+NWK9INcneA6sJ3b0Rh1ilWqOGWG f6kIiJosVG98cu33vmaGGX+GeXfsHJPX+0PKz9n0OjKY2PrjLYTTLAw5HwcniSIO4Ug1cr93 GXapLawFuyEAfufRVfd6usILmz7Z9ijoNGRmZB1JV+pzRzevTLkbbMLyoYui6tOv4kah8hh8 vaog7drGOT8rFDR0IbBtyD5k8j8hNQGLOUJEDeno67fR/BqwMpvkSrHB4zIWvbggbkOfFQ6z 6ysCPo/mhpVmGmUHmkWNtUnTfJVq6TIgpCCKslUHTfPLB2wet1EXCWSieWGffj/heo0Z0e+0 nUVWem+ZIVW1jVKfs+zIAIfrkQtbRGURS0mcrhBlZdw4XbRbsXhsQm8aHnXGWY4pJIawF91M kY/goHZn1kPF3/zHk3+P+K/61uOvrHush4u/+Y8m/wAf8V/1rcdfQIfxwft4aF/Bhq5/B8G6 aibQyL2NDJdXs3DNZFC55GD8Ml8ffd1sWR2LygU7CHwzzu3VQcdmpMU+dsnHdBZFbskvn3SV Tz9HPtKLQSG72utEtKnMQ2O1KBxNxqVrivFwkk0quKVSIPHVqdhqgQWflAzfuGjZIaHjcmzQ oeHRCKsTD5Fci0jYNu4TGNW19RuQ/wAUemHyGXh5j/QJbr7wYam6/Nl4ezsHYizKK7W8LvQf rXaE6ipalELMAskmcfkRcJHoDGJFLP0LFuy7Ng8mk5OOF0hILtLwsndiUXudoekw9RuQ/wAU emHyGXh5j/R6jch/ij0w+Qy8PMf6Bz+kwg37h+0fwYaF/wA4cj/R6jch/ij0w+Qy8PMf61iK 1v3tD3NPbxbbX6lKSyxKxqSqDY5fRS4so61jtMyq7JfF3otonyHJEkDT8lfEvQPuHZd8xdMR sbSHDhbhmTcmAo71Py8+NXXO5rcQ2Kj7uzdctk00OzN5sDrNN8qvsaQjfwUG+YuaoKi5BBZ+ yWRZsEF8ZzC5Eus0HshyjjIah2Z9809RuQ/xR6YfIZeHmP8AR6jch/ij0w+Qy8PMf6DRki4t IHb6odrtjs1tvt7CwhLEq2qO3rDhMVp4g/ZvlXYZ9KILQ9a0+jNXgvH8t2TxmRA8MzXRXzRG NGT90OzpVHo7H4iCDxeKAw8YjMeGswwCOx4YyCggYgchg1Hig4gag2HjBrFqkm2ZsWTdBq1Q TwRQSwTwxx7KR6jch/ij0w+Qy8PMf6PUbkP8UemHyGXh5j/QHI/+3hvp8GG0f8Hznpz+pxXZ rfvbfFNW3R0v2v1KGxO5qxntUSgjG9FLiZyJhHbEipWIG3oF2T5DjA1qaajTDlcW4IiCjFB8 mgq7HPm+KjZXZ3qNyH+KPTD5DLw8x/oGdsKu4JbMKkdcWdEI7PYFLxqgiTxCWCWZyPnByueC vdsRGP0lmy+Ka6SLpvnkn+K1doN3jZRF0girhOmHcWwCmWKsX1m3H3b1uq/J8o4YU9CLLrqe 13FGK6jldwNgTa+qjt2SQ5uou4/FxSYSVVljljmoqwXcq/mcN8+o3If4o9MPkMvDzH+j1G5D /FHph8hl4eY/0Hn65cfGuuts9kNzh2U0tXYaXNVGEq2OviYP7RugwMUTRQ7iG8lKJthsWC9m zdu07hoQCjApRm3btF2ards3TSd/pMPUbkP8UemHyGXh5j/R6jch/ij0w+Qy8PMf6Ag37h+0 fwYaF/zhyP8ATn9TiFa372h7mnt4ttr9SlJZYlY1JVBscvopcWUdax2mZVdkvi70W0T5DkiS Bp+SviXoH3Dsu+YumI2NpDhwtwzJuTGzvUbkP8UemHyGXh5j/QaA234hdYt6JSAlu0Mvvyy3 8Rbl2cOG52W1jUbiLI65aOiyEfjMTjIQIyVI5DhaRElkyWMFG4gSkUIvcRrPujQSrK5Xq6MN oplYlj2MyHotGowjZxkPJJEyZs22LZNutI2UfDGDmauOGKrkhJnZwsuv6SihDv6efbJevUbk P8UemHyGXh5j/R6jch/ij0w+Qy8PMf6Bz+kw30/6Pg3xn8cH+w/Vzo9RuQ/xR6YfIZeHmP8A Wsbb1v3tuaKiohKNr9SmA0PZ1J2u2XA6KXE1fKSKh7mgV4xBkuqR5DijfIKSlldhB0kbptkn zyOuijQYRDkl2hdiFHel12k1dqrcKqFaSusc9N1sQmEElkijzN8uNwkqcDlguXNI8TeM80X6 QUw8EoMjHYa6YkFR6rhJo+aq59lsddeo3If4o9MPkMvDzH+j1G5D/FHph8hl4eY/0GjgHFxD qqF9ovrDthutqzXaaeTZnVNbXFH53XANm7eNlyicTEbD1/dRiGLuEk3X5LOKyAQyHP3ipDEe 4+9Zs43ZqfoTQuoBOfzODdpxYNyW07SeWtsDdcsXsa7LC7t+6XdozOzB00YIMw7X8u2/CAxs SBCZZs2Kq49Zdi0VQ/X1G5D/ABR6YfIZeHmP9HqNyH+KPTD5DLw8x/oHP6yHi7/5jyb/AB/x X/Wtx19If6jch/ij0w+Qy8PMf6bzh5Y2INy5H2VrymFzSfo7/hf16TV7AjlYw8l+Jx1cfKwv 9Ig8ksi3DQT8mFUHDyH52wpB+pFGr0u3/SWhBAGNBQ+OD9vDQv4MNXP4Pg3Tn9aipPjB3toe mqko6Ib2alEonTNYwKqIuRknHXcTyRP47XcVFRAI9PuxnJiHGujToaHbLlHA4QLYrvlF1Wg5 i3yTbJbO9hjkP8cGmH047w80LoIZaynOSl4QpOdmsbWOvIfx1aqSeyqVuONKwcBct2yae363 vON+uUmAiO1f7LgY8CrQkNSKkWoJlg5GR6xwYUHNWE4in0VcX3vtpTTvIxG7oAMpV7zuQ22B t8hcNH/oDQPtlDmeqQmyJHVbPEyDOtadIlm9YgnRT9El0VQMGRTmQshjcnjcX2GOQ/xwaYfT jvDzQuj2GOQ/xwaYfTjvDzQugnhPB1rRezarjNlOrtZa1YU4W7G++vpW+bOkpTYcnL8cXIic TyGsZBsqzgbCJEVCMCOMSEcjyD9qZZTMsyTHwoMut8yfbpSElAAlVdruJ0se3piQaGP7OZ2r WE9y147akW+XsBvbcgj4EXdsTqgdsMMjjWHTGxxgGcEzioQAUJE40Rij0zZ/2GOQ/wAcGmH0 47w80Lo9hjkP8cGmH047w80LoIvSRhup2j2xdZuDd9VxLTVzaLxuve1Zt57ccQiVRSnaOv4r eNxVVsZOB5uTSB+Wqk5IXFsVpPGYBxSI6BGJQgHfQGRoTspmKVr7szOwdcJDK4TaNbRGlLRc VZskDiFfyR+JvSXtK2uF3OrNjLBsGIH3+ugxaG1iYqI6NR7pTCUXG4hpHLGXV8iOe1w9hjkP 8cGmH047w80Lo9hjkP8AHBph9OO8PNC6CVdfzzc8fLIhcluVnZSlP7EzA5H5tVARcoYnmucE sNOIR7XIkLikK7JyiPPYQmMIvNmSKDdU5HpVcEqlq8nbQOlI+yaZbEojcIeV8ijz83sEs2rg 21YamYHZvchwURDldN6tOFVIWxPnyAy0/wAK7j89QbkiTeXug8zQdR4a6YuY0wGCqT+wxyH+ ODTD6cd4eaF0ewxyH+ODTD6cd4eaF0Ekqzk11ucIfluF7WIyKKa064FK9RpiF3uu8JWQrWLU 1fpC41NdYs9tYLbImfsMhuEPsFYTA3wRwNYR0AclZKYMmvzBPeAS2QUQnHJbPIS1FG9vpFHS NuwVq6D2NW0elVVNNd43tWLjAQU6hZiXw01Oko7mwVilpC8RoiXygKUl4edwl/Xb2GOQ/wAc GmH047w80Lo9hjkP8cGmH047w80LoI+vrI2vsGJ3dIZDH9laFTZ7xQ0WwijeqZXZndpT8W0/ pDtNYkPdVKREW2aouX7HoWCiEuzXRtJTzmRuUHj4cMhLueIAdk1Vja831/2QalQmyYAhCMZC TosgVsO/GZkyRTqpFVgOhWNh13R2zB0aPmCayrgDd7S1kiMlKKIRifSgI2agovTn2GOQ/wAc GmH047w80Lo9hjkP8cGmH047w80LoI522rsfBNWePw9GW2xBidTWyqZfbZsO7zaKYShuEI6p XCTmqc3GVgOnNuVvH0rlShOJljCI8DYjZf8AoQR+0YtXKjbvn7qc3S8qaGrxANeYQD7SEfY7 DvYrF9sDlqCNfXVeSldwVrQdtZX4m0SztazmcECzJGoIvIzgevyUnLQvFvN+yT0dU32GOQ/x waYfTjvDzQuj2GOQ/wAcGmH047w80LoJgziRz5GAWvnq4nuk6eYSfXBQL/5iiVmdoyPIFth4 w2sxnCE7vBIbPFEFq9dln1jrq4GadjUFTa9oY+AkWclaJY5trIt5w8quFKCN5OsMbcYW88ig Pek4tMzg7LaMMRpbGjG7ZZcSRxdW2s3eTPvW8XY5rGDyGEjyYCCPZit3b1h9hjkP8cGmH047 w80Lo9hjkP8AHBph9OO8PNC6CYz41udAdm9NaQPM7GsipkbWtV9L9k40GFKxya1Ax1lutSJR bZRgAatUIHZgC1+9dpIyJiDDVxaRRMAbja8ekr4zW4NUKUk3KsfjNdojWUxbmVOOLUSV2Ivc YIhFJe4vtzZ16o3jGa6xncM/8ZCtki0DaxVR1lbSi8WhhRlXaE2gziOTF1II9ej2GOQ/xwaY fTjvDzQuj2GOQ/xwaYfTjvDzQug11SJkeeqmEExrO1GDdUKkiqzu4RJglrNyDVRVqUSm7GWN 2xPuaxJIu+yr1livGSKf4T+HPH0TcBXayV2tJLHHXddSdujthnFZsh1dZawCKOGX/hBpCl6v NnthErFluqEIntrBZwzn+BMWsMnTPGCOYIhD84rHCxIhO3fVGfYY5D/HBph9OO8PNC6PYY5D /HBph9OO8PNC6CHiM936xnGvk4Dx/YztC6ep/aueWBAJfH/WBxsIHgexdSQyAxuRPBlZVm5Q taY64SWxZ3QkXNRKE2WdlEWA5zuOu3yc4Tz829pnvwoE2NsqOsL7YsrBC6YTmpazi0KsVw5r OEE9z2cKsGINmUCiRCw21gmdZgiNk7AgwzItPq7UnMkGMk0RkaAOMbq+wxyH+ODTD6cd4eaF 0ewxyH+ODTD6cd4eaF0EVWEv3Mxi21C0JYXMsIdV7Sxqlklo3sO7cRiwMLSMBrFED8dk62h9 6m3Z+JZBSL1mFbyaFAI0CXIZZgTR1VzIXUKE9oENzdbxJpPDKlCNKbTPJ+rXwiVOIOnOBh/W zCscJ4aKM1R4s6qPI2N3gjFR+zcFmyc0Ubt3uItfJo63sMch/jg0w+nHeHmhdHsMch/jg0w+ nHeHmhdB9/WQ8Xf/ADHk3+P+K/61uOvrD/YY5D/HBph9OO8PNC6azRvVKxNWhGwjm17hhd0T /YbYBK9Dx6vadOUfDwH5DX+gtfhcWEQySXPfJpb8ELQw6QEDb2fKfnikhet24ga0Yodlw//Z --------------070203010502000309060005-- --------------070705000607040305060607-- From milen@radev.net Thu Sep 20 16:04:18 2007 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 0AB6F9FA248 for ; Thu, 20 Sep 2007 13:04:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 12456-01 for ; Thu, 20 Sep 2007 13:04:05 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ciao.gmane.org (main.gmane.org [80.91.229.2]) by postgresql.org (Postfix) with ESMTP id D995F9FA321 for ; Thu, 20 Sep 2007 13:04:05 -0300 (ADT) Received: from list by ciao.gmane.org with local (Exim 4.43) id 1IYORi-0002y4-16 for pgsql-admin@postgresql.org; Thu, 20 Sep 2007 18:00:06 +0200 Received: from pirus.securax.be ([213.16.46.130]) by main.gmane.org with esmtp (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 20 Sep 2007 18:00:06 +0200 Received: from milen by pirus.securax.be with local (Gmexim 0.1 (Debian)) id 1AlnuQ-0007hv-00 for ; Thu, 20 Sep 2007 18:00:06 +0200 X-Injected-Via-Gmane: http://gmane.org/ To: pgsql-admin@postgresql.org From: "Milen A. Radev" Subject: Re: How to update from 8.1 to 8.2 ? Date: Thu, 20 Sep 2007 18:58:24 +0300 Lines: 10 Message-ID: References: <46F294F1.50004@joops.com> Mime-Version: 1.0 Content-Type: text/plain; charset=UTF-8 Content-Transfer-Encoding: 8bit X-Complaints-To: usenet@sea.gmane.org X-Gmane-NNTP-Posting-Host: pirus.securax.be User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) In-Reply-To: <46F294F1.50004@joops.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/124 X-Sequence-Number: 26885 Josef Springer написа: > Where is the documentation of the steps dto do for updating e.g. from 8.1 to 8.2 ? > I have never done this and could not find any docs for. [...] http://www.postgresql.org/docs/8.2/static/install-upgrading.html -- Milen A. Radev From walterc@indiana.edu Thu Sep 20 16:39:13 2007 Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 0DAF29F9A70 for ; Thu, 20 Sep 2007 13:39:13 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 99370-03 for ; Thu, 20 Sep 2007 13:39:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from hartman.uits.indiana.edu (hartman.uits.indiana.edu [129.79.1.194]) by postgresql.org (Postfix) with ESMTP id 5534F9F99BD for ; Thu, 20 Sep 2007 13:39:00 -0300 (ADT) Received: from mail-relay.iu.edu (stjoseph.uits.indiana.edu [129.79.1.78]) by hartman.uits.indiana.edu (8.13.8/8.13.8/IU Messaging Team) with ESMTP id l8KGcxDk029951; Thu, 20 Sep 2007 12:38:59 -0400 Received: from [129.79.36.69] (walter.slis.indiana.edu [129.79.36.69]) (authenticated bits=0) by mail-relay.iu.edu (8.13.6/8.12.10/IUPO) with ESMTP id l8KGcvnN015314 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO); Thu, 20 Sep 2007 12:38:58 -0400 (EDT) In-Reply-To: References: <46F294F1.50004@joops.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: text/plain; charset=UTF-8; delsp=yes; format=flowed Message-Id: <5A8931AD-0807-4641-AB12-D8565A385B58@indiana.edu> Cc: pgsql-admin@postgresql.org Content-Transfer-Encoding: quoted-printable From: Carol Walter Subject: Re: How to update from 8.1 to 8.2 ? Date: Thu, 20 Sep 2007 12:38:57 -0400 To: "Milen A. Radev" X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/125 X-Sequence-Number: 26886 We just did this. I did a pg_dumpall using 8.1. Then we fired up =20 8.2 while 8.1 was still running. Uploaded the data to 8.2. Then =20 shut 8.1 down. This allowed us to have the database unavailable for =20 a very short time. Carol On Sep 20, 2007, at 11:58 AM, Milen A. Radev wrote: > Josef Springer =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0: >> Where is the documentation of the steps dto do for updating e.g. =20 >> from 8.1 to 8.2 ? >> I have never done this and could not find any docs for. > [...] > > http://www.postgresql.org/docs/8.2/static/install-upgrading.html > > > --=20 > Milen A. Radev > > > ---------------------------(end of =20 > broadcast)--------------------------- > TIP 6: explain analyze is your friend From revoohc@gmail.com Thu Sep 20 18:06:45 2007 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id CA0459F9B90 for ; Thu, 20 Sep 2007 15:06:45 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 44778-06-2 for ; Thu, 20 Sep 2007 15:06:36 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.5 Received: from ug-out-1314.google.com (ug-out-1314.google.com [66.249.92.174]) by postgresql.org (Postfix) with ESMTP id 84EDD9F9BB4 for ; Thu, 20 Sep 2007 15:06:38 -0300 (ADT) Received: by ug-out-1314.google.com with SMTP id j3so462138ugf for ; Thu, 20 Sep 2007 11:06:37 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; bh=qQ8VdHg0QliAKEXQYNfcqM3aGu0fA79FgIYljam3bDs=; b=gkS3SzL5aEc4OXyta219JiT4MAYBmjI0RS04eGhKGUCEs1+Eo3ZWbWYT3b1bK0B8xYxNfuJ6xyzR8zqy8/CnCq4O3vLn/9wK0GusroZQkkrLNQkWzUw7ZtZftdlCaSb9RLF9XPiw2IaxJFlDCUJALoRgj48zwmxRcJO1/VIk8SM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:message-id:date:from:to:subject:cc:in-reply-to:mime-version:content-type:references; b=pdsEqsMGNjJHmFfw7ktnnCYPscqq/vqoCCvMnFiu7wlAiLyaI0kzmDXbkdaCd9gmENzoXhyZR5uXMeA1F7S2jOdeifPwvKNnqGyyGwG2bkcQdyNvNA5yE50L/5p9i9tsoqFy3HKA/PWdVSIHu9redMguZ7ArlhrvCB4lV/YK+1A= Received: by 10.78.172.20 with SMTP id u20mr1453915hue.1190311596472; Thu, 20 Sep 2007 11:06:36 -0700 (PDT) Received: by 10.78.201.16 with HTTP; Thu, 20 Sep 2007 11:06:36 -0700 (PDT) Message-ID: <1d219a6f0709201106n24c000a7p9006f5b7257f2d69@mail.gmail.com> Date: Thu, 20 Sep 2007 14:06:36 -0400 From: "Chris Hoover" To: "Carol Walter" Subject: Re: How to update from 8.1 to 8.2 ? Cc: "Milen A. Radev" , pgsql-admin@postgresql.org In-Reply-To: <5A8931AD-0807-4641-AB12-D8565A385B58@indiana.edu> MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_31846_19197877.1190311596456" References: <46F294F1.50004@joops.com> <5A8931AD-0807-4641-AB12-D8565A385B58@indiana.edu> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/127 X-Sequence-Number: 26888 ------=_Part_31846_19197877.1190311596456 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline On 9/20/07, Carol Walter wrote: > > We just did this. I did a pg_dumpall using 8.1. Then we fired up > 8.2 while 8.1 was still running. Uploaded the data to 8.2. Then > shut 8.1 down. This allowed us to have the database unavailable for > a very short time. > > Carol Carol, If this is truely what you did, you are a very lucky person. You are always supposed to dump the old database using the new versions pg_dump/pg_dumpall. That way, pg_dump/pg_dumpall can set up the data for any changes made by the newer version. Just an fyi for those following this thread. HTH, chris ------=_Part_31846_19197877.1190311596456 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: 7bit Content-Disposition: inline

On 9/20/07, Carol Walter <walterc@indiana.edu> wrote:
We just did this.  I did a pg_dumpall using 8.1.  Then we fired up
8.2 while 8.1 was still running.  Uploaded the data to 8.2.  Then
shut 8.1 down.  This allowed us to have the database unavailable for
a very short time.

Carol


Carol,

If this is truely what you did, you are a very lucky person.  You are always supposed to dump the old database using the new versions pg_dump/pg_dumpall.  That way, pg_dump/pg_dumpall can set up the data for any changes made by the newer version.

Just an fyi for those following this thread.

HTH,

chris


------=_Part_31846_19197877.1190311596456-- From walterc@indiana.edu Fri Sep 21 15:30:50 2007 Received: from localhost (unknown [200.46.204.182]) by postgresql.org (Postfix) with ESMTP id 0B5369F99B2 for ; Fri, 21 Sep 2007 12:30:50 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024) with ESMTP id 06992-03 for ; Fri, 21 Sep 2007 12:30:30 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from belushi.uits.indiana.edu (belushi.uits.indiana.edu [129.79.1.188]) by postgresql.org (Postfix) with ESMTP id 4F0939F9BA5 for ; Fri, 21 Sep 2007 12:30:30 -0300 (ADT) Received: from mail-relay.iu.edu (logchain.uits.indiana.edu [129.79.1.77]) by belushi.uits.indiana.edu (8.13.8/8.13.8/IU Messaging Team) with ESMTP id l8LFUQUV006770; Fri, 21 Sep 2007 11:30:26 -0400 Received: from [129.79.36.69] (walter.slis.indiana.edu [129.79.36.69]) (authenticated bits=0) by mail-relay.iu.edu (8.13.6/8.12.10/IUPO) with ESMTP id l8LFUOnA000767 (version=TLSv1/SSLv3 cipher=AES128-SHA bits=128 verify=NO); Fri, 21 Sep 2007 11:30:25 -0400 (EDT) In-Reply-To: <1d219a6f0709201106n24c000a7p9006f5b7257f2d69@mail.gmail.com> References: <46F294F1.50004@joops.com> <5A8931AD-0807-4641-AB12-D8565A385B58@indiana.edu> <1d219a6f0709201106n24c000a7p9006f5b7257f2d69@mail.gmail.com> Mime-Version: 1.0 (Apple Message framework v752.2) Content-Type: multipart/alternative; boundary=Apple-Mail-6--519457666 Message-Id: <3069AA17-872B-4AB0-810A-14B1754BF7A3@indiana.edu> Cc: "Milen A. Radev" , pgsql-admin@postgresql.org From: Carol Walter Subject: Re: How to update from 8.1 to 8.2 ? Date: Fri, 21 Sep 2007 11:30:23 -0400 To: Chris Hoover X-Mailer: Apple Mail (2.752.2) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200709/135 X-Sequence-Number: 26896 --Apple-Mail-6--519457666 Content-Transfer-Encoding: 7bit Content-Type: text/plain; charset=US-ASCII; delsp=yes; format=flowed Chris, Perhaps I wasn't clear on what we did. We loaded the 8.2 and got it running on a different zone on the same machine running Solaris. I should have said we did a pg_dumpall using the 8.1 data. ( I know there is a big difference.) Anyway, I did the pg_dumpall (using the correct version, the new version.) of the live data and uploaded it to the 8.2 instance. The 8.1 instance was still running. Both systems automount the same dirs. We were able to put the data from the 8.1 instance onto a directory that the 8.2 instance could see, which made the cut over very quick and the production system just had to be down long enough to stop and restart. I had already modified the conf files and we didn't blow them away so we were good to go. I just froze data entry from when I started the dump until the new instance was available. That meant people could still select data from the website. After the 8.2 instance was up and running and everything looked like in came over correctly, we shut down the 8.1 instance. Sorry about the confusion. Carol On Sep 20, 2007, at 2:06 PM, Chris Hoover wrote: > > > On 9/20/07, Carol Walter wrote: > We just did this. I did a pg_dumpall using 8.1. Then we fired up > 8.2 while 8.1 was still running. Uploaded the data to 8.2. Then > shut 8.1 down. This allowed us to have the database unavailable for > a very short time. > > Carol > > > Carol, > > If this is truely what you did, you are a very lucky person. You > are always supposed to dump the old database using the new versions > pg_dump/pg_dumpall. That way, pg_dump/pg_dumpall can set up the > data for any changes made by the newer version. > > Just an fyi for those following this thread. > > HTH, > > chris > > --Apple-Mail-6--519457666 Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=ISO-8859-1 Chris,

Perhaps I wasn't clear on = what we did.=A0 We loaded the 8.2 and got it running on a different zone = on the same machine running Solaris.=A0 I should have said we did a = pg_dumpall using the 8.1 data.=A0 ( I know there is a big difference.)=A0 = Anyway, I did the pg_dumpall (using the correct version, the new = version.)=A0of the live data and uploaded it to the 8.2 instance.=A0 The = 8.1 instance was still running.=A0 Both systems automount the same = dirs.=A0 We were able to put the data from the 8.1 instance onto a = directory that the 8.2 instance could see, which made the cut over very = quick and the production system just had to be down long enough to stop = and restart.=A0 I had already modified the conf files and we didn't blow = them away so we were good to go.=A0 I just froze data entry from when I = started the dump until the new instance was available.=A0 That meant = people could still select data from the website.=A0 After the 8.2 = instance was up and running and everything looked like in came over = correctly, we shut down the 8.1 instance.

Sorry about the = confusion.

Carol

On Sep 20, 2007, at 2:06 PM, Chris Hoover wrote:



On 9/20/07, Carol Walter <walterc@indiana.edu> = wrote:
We just did this.=A0=A0I did a pg_dumpall using 8.1.=A0=A0Then we = fired up
8.2 while 8.1 was still running.=A0=A0Uploaded the data to = 8.2.=A0=A0Then
shut 8.1 down.=A0=A0This allowed us to have the = database unavailable for
a very short time. =

Carol


Carol,

If this is truely = what you did, you are a very lucky person.=A0 You are always supposed to = dump the old database using the new versions pg_dump/pg_dumpall.=A0 That = way, pg_dump/pg_dumpall can set up the data for any changes made by the = newer version.

Just an fyi for those following this = thread.

HTH,

chris



= --Apple-Mail-6--519457666-- From sanya-spb@list.ru Mon Oct 15 12:55:51 2007 Received: from localhost (unknown [200.46.204.184]) by postgresql.org (Postfix) with ESMTP id 5DF039F9A9A for ; Mon, 15 Oct 2007 09:55:51 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.184]) (amavisd-maia, port 10024) with ESMTP id 30847-04 for ; Mon, 15 Oct 2007 09:55:43 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from mx4.mail.ru (fallback.mail.ru [194.67.57.14]) by postgresql.org (Postfix) with ESMTP id BD08C9F9A8D for ; Mon, 15 Oct 2007 09:55:50 -0300 (ADT) Received: from mx30.mail.ru (mx30.mail.ru [194.67.23.238]) by mx4.mail.ru (mPOP.Fallback_MX) with ESMTP id D5C8E53CA53 for ; Mon, 15 Oct 2007 16:53:06 +0400 (MSD) Received: from [62.141.119.51] (port=39857 helo=fujik.local) by mx30.mail.ru with asmtp id 1IhPRI-000B3v-00; Mon, 15 Oct 2007 16:52:56 +0400 From: Alexander Kuprijanov To: pgsql-admin@postgresql.org Subject: Re: How to update from 8.1 to 8.2 ? Date: Mon, 15 Oct 2007 16:52:43 +0400 User-Agent: KMail/1.9.6 (enterprise 0.20070907.709405) Cc: "Milen A. Radev" References: <46F294F1.50004@joops.com> In-Reply-To: MIME-Version: 1.0 Content-Type: text/plain; charset="utf-8" Content-Transfer-Encoding: quoted-printable Content-Disposition: inline Message-Id: <200710151652.43409.sanya-spb@list.ru> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/114 X-Sequence-Number: 27028 Hello Does exist another way to make upgrade (without dump-restore)? I have this question, because I have very big DB (or very poor server): dum= p=20 ~40min, restore >2h I can't stop my DB so long... Thanks =D0=92 =D1=81=D0=BE=D0=BE=D0=B1=D1=89=D0=B5=D0=BD=D0=B8=D0=B8 =D0=BE=D1=82 = Thursday 20 September 2007 19:58:24 Milen A. Radev =D0=BD=D0=B0=D0=BF=D0=B8= =D1=81=D0=B0=D0=BB(=D0=B0): > Josef Springer =D0=BD=D0=B0=D0=BF=D0=B8=D1=81=D0=B0: > > Where is the documentation of the steps dto do for updating e.g. from 8= =2E1 > > to 8.2 ? I have never done this and could not find any docs for. > > [...] > > http://www.postgresql.org/docs/8.2/static/install-upgrading.html =2D-=20 Se okulo ne atentas, dorso eksentas From ktm@rice.edu Mon Oct 15 13:04:23 2007 Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id 0A86D9F9A34 for ; Mon, 15 Oct 2007 10:04:23 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 93056-07 for ; Mon, 15 Oct 2007 10:04:10 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from is.rice.edu (is.rice.edu [128.42.42.24]) by postgresql.org (Postfix) with ESMTP id 291139F98F6 for ; Mon, 15 Oct 2007 10:04:16 -0300 (ADT) Received: from scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) by is.rice.edu (Postfix) with ESMTP id BA84D41894; Mon, 15 Oct 2007 08:04:14 -0500 (CDT) Received: from is.rice.edu ([128.42.42.24]) by scan1.mail.rice.edu (scan1.mail.rice.edu [128.42.58.160]) (amavisd-new, port 10024) with ESMTP id 25306-08; Mon, 15 Oct 2007 08:04:14 -0500 (CDT) Received: by is.rice.edu (Postfix, from userid 18612) id 0A0D941893; Mon, 15 Oct 2007 08:04:13 -0500 (CDT) Date: Mon, 15 Oct 2007 08:04:13 -0500 From: Kenneth Marshall To: Alexander Kuprijanov Cc: pgsql-admin@postgresql.org, "Milen A. Radev" Subject: Re: How to update from 8.1 to 8.2 ? Message-ID: <20071015130413.GT12467@it.is.rice.edu> References: <46F294F1.50004@joops.com> <200710151652.43409.sanya-spb@list.ru> MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <200710151652.43409.sanya-spb@list.ru> User-Agent: Mutt/1.5.16 (2007-06-09) X-Virus-Scanned: by amavis-2.2.1 at scan1.mail.rice.edu X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/116 X-Sequence-Number: 27030 Use Slony to replicate to the new version from the old version. Once they are sync-ed up, you switch the new version to be the master and re-point your apps to the new DB. Ken On Mon, Oct 15, 2007 at 04:52:43PM +0400, Alexander Kuprijanov wrote: > Hello > > Does exist another way to make upgrade (without dump-restore)? > > I have this question, because I have very big DB (or very poor server): dump > ~40min, restore >2h > > I can't stop my DB so long... > > > > Thanks > > > ?? ?????????????????? ???? Thursday 20 September 2007 19:58:24 Milen A. Radev ??????????????(??): > > Josef Springer ????????????: > > > Where is the documentation of the steps dto do for updating e.g. from 8.1 > > > to 8.2 ? I have never done this and could not find any docs for. > > > > [...] > > > > http://www.postgresql.org/docs/8.2/static/install-upgrading.html > > > > -- > Se okulo ne atentas, dorso eksentas > > ---------------------------(end of broadcast)--------------------------- > TIP 9: In versions below 8.0, the planner will ignore your desire to > choose an index scan if your joining column's datatypes do not > match >