Received: from localhost (unknown [200.46.204.183]) by postgresql.org (Postfix) with ESMTP id 6F30D650E7B for ; Sun, 29 Jun 2008 06:49:11 -0300 (ADT) Received: from postgresql.org ([200.46.204.86]) by localhost (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 64408-06 for ; Sun, 29 Jun 2008 06:49:00 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx.inode.at (mx19.lb01.inode.at [62.99.145.21]) by postgresql.org (Postfix) with ESMTP id B87B3650DBC for ; Sun, 29 Jun 2008 06:49:02 -0300 (ADT) Received: from [212.183.59.2] (port=5452 helo=[10.0.0.5]) by smartmx-19.inode.at with esmtpsa (TLS-1.0:DHE_RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1KCtWm-0002mX-0n; Sun, 29 Jun 2008 11:49:00 +0200 Message-ID: <48675C09.3070303@x-ray.at> Date: Sun, 29 Jun 2008 11:55:21 +0200 From: Reini Urban User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; de-AT; rv:1.8.1.13) Gecko/20080313 SeaMonkey/1.1.9 MIME-Version: 1.0 To: Nick Texidor CC: pgsql-cygwin@postgresql.org Subject: Re: Updating postgres 7.4.5 to 8 via cygwin References: In-Reply-To: Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests=none X-Spam-Level: X-Archive-Number: 200806/6 X-Sequence-Number: 4394 Nick Texidor schrieb: > I was wondering whether someone can help me. I already have postgres > 7.4.5 running under cygwin on my web server, and I've looked into > installing the native version of 8, but it looks like there is a bit of > dumping/importing of database to be done. I noticed that postgres 8 is > available under cygwin, and it came up as an update. If I install it > through cygwin, is there any messing around with databases to be done? > Is that an easier option than installing the native version and moving > from a cygwin version? Installing a native version will create a new database. Upgrading cygwin to 8 will leave you with a non-accessible database. So if you need the data from the old database, you MUST export it. See the cygwin announcement, which describes it in detail. http://article.gmane.org/gmane.os.cygwin.announce/2310 Which says: Before you upgrade a postgresql package to a new new major or minor version (7.4 => 8.0 => 8.1 => 8.2), be sure to dump all your data before! With the new package you will not be able to access your old databases. => http://www.postgresql.org/docs/8.2/static/app-pg-dumpall.html Minor subrelease updates (e.g. 8.2.4 to 8.2.5) can safely access the same database. -- Reini Urban http://phpwiki.org/ http://murbreak.at/