From: Reini Urban <rurban@x-ray.at>
To: Nick Texidor <nick@texidor.com>
Cc: pgsql-cygwin@postgresql.org
Subject: Re: Updating postgres 7.4.5 to 8 via cygwin
Date: Sun, 29 Jun 2008 11:55:21 +0200
Message-ID: <48675C09.3070303@x-ray.at> (raw)
In-Reply-To: <aad06ecb0806290113u4ff06db5h32d54d5d67b71337@mail.gmail.com>
References: <aad06ecb0806290113u4ff06db5h32d54d5d67b71337@mail.gmail.com>
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/
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-cygwin@postgresql.org
Cc: rurban@x-ray.at, nick@texidor.com
Subject: Re: Updating postgres 7.4.5 to 8 via cygwin
In-Reply-To: <48675C09.3070303@x-ray.at>
References: <aad06ecb0806290113u4ff06db5h32d54d5d67b71337@mail.gmail.com> <48675C09.3070303@x-ray.at>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox