Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0

From: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
To: "Jim C(dot) Nasby" <decibel(at)decibel(dot)org>
Cc: Tino Wildenhain <tino(at)wildenhain(dot)de>, Jeff Davis <jdavis-pgsql(at)empires(dot)org>, schen(at)graciousstyle(dot)com, PgSQL General List <pgsql-general(at)postgresql(dot)org>, pgsql-docs(at)postgresql(dot)org
Subject: Re: Fast major-version upgrade (was: [GENERAL] postgresql 8.0
Date: 2005-03-17 05:02:55
Message-ID: 200503170502.j2H52ta00621@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs pgsql-general

Jim C. Nasby wrote:
> > > 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.
> >
> > I used a straight copy of the filesystem with running database
> > (over the net in my case) and immediately after that,
> > stop the db and rsync for the last changes. This took only
> > 10 minutes (compared to 1.5h for the full filesystem copy)
> > and I could start up the db in new location.
> >
> > this could work for you too.
>
> I hadn't thought about using rsync; that's a great idea!
>
> Is there somewhere this could be documented? In an FAQ maybe?

Added to documentation, patch attached.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Attachment Content-Type Size
unknown_filename text/plain 998 bytes

In response to

Browse pgsql-docs by date

  From Date Subject
Next Message Bruce Momjian 2005-03-17 20:24:35 Re: question about markup
Previous Message Bruce Momjian 2005-03-15 23:09:31 Re: replace palloc/pfree with malloc/free

Browse pgsql-general by date

  From Date Subject
Next Message Christopher Browne 2005-03-17 05:22:47 Re: Best practices: Handling Daylight-saving time
Previous Message Michael Fuhr 2005-03-17 03:48:16 Re: help with plpgsql function called by trigger