public inbox for [email protected]
help / color / mirror / Atom feedFrom: Christopher Browne <[email protected]>
To: [email protected]
Subject: Re: postgresql 8.0 advantages
Date: Sat, 26 Feb 2005 21:12:54 -0500
Message-ID: <[email protected]> (raw)
References: <[email protected]>
<[email protected]>
<[email protected]>
<1109410075.4089.216.camel@jeff>
<[email protected]>
The world rejoiced as [email protected] ("Jim C. Nasby") wrote:
> On Sat, Feb 26, 2005 at 01:27:55AM -0800, Jeff Davis wrote:
>> On Fri, 2005-02-25 at 09:20 -0800, Si Chen wrote:
>> > Thanks!
>> >
>> > Is there any documentation on how to upgrade to 8.0?
>> >
>> > Is it possible to upgrade from 7.4 to 8.0 while keeping a production
>> > database running "in place"? Or should I install 8.0 in another
>> > directory/machine and then restore the database into it? Are there any
>> > incompatibilities/modifications to databases from the earlier veresion
>> > required?
>> >
>>
>> You might want to check out Slony-I <http://www.slony.info; for the
>> purpose of upgrading. Slony is actually a replication engine, but it can
>> be used to upgrade with little or no downtime. Otherwise, just
>> dump/upgrade/restore like normal.
>
> Has anyone tried moving a database from one location to another on the
> HD? I'd like to use slony to minimize downtime, but I'd also like my
> data to end up in the same place it is right now when I'm done.
Yes, that certainly ought to work.
If what you're meaning is that you make a replica that sits in
/opt/VERSION8, and then, once the upgrade is complete, rename that to
/opt/MYDATABASE which was where your version 7.4 DB used to be.
We have copied databases from one server to another by copying the
files; making it work was as easy as making sure we ran "pg_ctl -D
$RIGHT_DIRECTORY start" :-).
--
let name="cbbrowne" and tld="cbbrowne.com" in name ^ "@" ^ tld;;
http://cbbrowne.com/info/lisp.html
"I don't know why, but first C programs tend to look a lot worse than
first programs in any other language (maybe except for FORTRAN, but
then I suspect all FORTRAN programs look like `firsts')" -- Olaf Kirch
view thread (15+ messages) latest in thread
reply
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 using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: postgresql 8.0 advantages
In-Reply-To: <[email protected]>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox