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

2005-03-01 Thread Jim C. Nasby
On Mon, Feb 28, 2005 at 09:27:46PM +0100, Martijn van Oosterhout wrote: > On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote: > > > 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 th

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

2005-02-28 Thread Martijn van Oosterhout
On Mon, Feb 28, 2005 at 01:36:59PM -0600, Jim C. Nasby wrote: > > 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 fil

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

2005-02-28 Thread Jim C. Nasby
On Sun, Feb 27, 2005 at 09:27:41PM +0100, Tino Wildenhain wrote: > Hi, > > Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby: > > 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

Re: [GENERAL] postgresql 8.0 advantages

2005-02-28 Thread Tino Wildenhain
Hi, Am Samstag, den 26.02.2005, 15:35 -0600 schrieb Jim C. Nasby: > 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 upgra

Re: [GENERAL] postgresql 8.0 advantages

2005-02-27 Thread Christopher Browne
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 th

Re: [GENERAL] postgresql 8.0 advantages

2005-02-27 Thread Julian Scarfe
From: "Tom Lane" <[EMAIL PROTECTED]> There are some speed improvements in 8.0 too, though that wasn't the main focus of the release cycle. For instance, Lonni Friedman's nearby thread reports on a case where 8.0 consistently finds a much better query plan for a complex query than prior releases di

Re: [GENERAL] postgresql 8.0 advantages

2005-02-26 Thread Christopher Browne
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

Re: [GENERAL] postgresql 8.0 advantages

2005-02-26 Thread Jim C. Nasby
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"?

Re: [GENERAL] postgresql 8.0 advantages

2005-02-26 Thread Jeff Davis
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 t

Re: [GENERAL] postgresql 8.0 advantages

2005-02-25 Thread Lonni J Friedman
On Fri, 25 Feb 2005 09:20:29 -0800, Si Chen <[EMAIL PROTECTED]> wrote: > Thanks! > > Is there any documentation on how to upgrade to 8.0? Dump your DB, install 8.0, reload your DB. Since you'e using RHEL3, you should use the RPMs and it will be fairly easy. > Is it possible to upgrade from 7.4

Re: [GENERAL] postgresql 8.0 advantages

2005-02-25 Thread Si Chen
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/modificatio

Re: [GENERAL] postgresql 8.0 advantages

2005-02-25 Thread Tom Lane
Si Chen <[EMAIL PROTECTED]> writes: > I read the PostgreSQL 8.0 "What's New" page > (http://www.postgresql.org/docs/whatsnew) and wasn't sure whether > version 8.0 is significantly faster, more scalability, or more stable > than versions 7.4? I remember big speed improvements between 7.3 and >

Re: [GENERAL] postgresql 8.0 advantages

2005-02-25 Thread Richard_D_Levine
ubject: Re: [GENERAL] postgresql 8.0 advantages

Re: [GENERAL] postgresql 8.0 advantages

2005-02-25 Thread Sean Davis
On Feb 25, 2005, at 9:41 AM, Si Chen wrote: Hello. I read the PostgreSQL 8.0 "What's New" page (http://www.postgresql.org/docs/whatsnew) and wasn't sure whether version 8.0 is significantly faster, more scalability, or more stable than versions 7.4? I remember big speed improvements between 7.3

[GENERAL] postgresql 8.0 advantages

2005-02-25 Thread Si Chen
Hello. I read the PostgreSQL 8.0 "What's New" page (http://www.postgresql.org/docs/whatsnew) and wasn't sure whether version 8.0 is significantly faster, more scalability, or more stable than versions 7.4? I remember big speed improvements between 7.3 and 7.4. It seems the biggest advantage o