Skip site navigation (1) Skip section navigation (2)

Re: Question to safe way for minor update

From: Peter Eisentraut <peter_e(at)gmx(dot)net>
To: pgsql-admin(at)postgresql(dot)org
Cc: "Thomas Papke" <tp(at)thopap(dot)de>
Subject: Re: Question to safe way for minor update
Date: 2007-02-13 20:11:23
Message-ID: (view raw or whole thread)
Lists: pgsql-admin
Thomas Papke wrote:
> 1. i am running a large postgres 8.1.4 database in production. What
> is a good and safe way for an minor update to 8.1.8 (less downdown
> and possible jump back option)?

Using binary packages, install the new one over the old one, and if you 
don't like it, install the old one over the new one.

> How riskful is an minor update for the data files?

Not riskful.

> 2. i am using two dualcore opterons with 8GB memory - if i am using
> the CFLAGS="-O2" option for compile optimization --> is there any
> real performance boost?

I don't think anyone has ever seriously considered building with 
anything less than -O2 for anything but debugging purposes or coping 
with buggy compilers on rare architectures.  In other words, there 
isn't any good reason not to do it.

Peter Eisentraut

In response to


pgsql-admin by date

Next:From: Thomas PapkeDate: 2007-02-13 21:08:17
Subject: Re: Question to safe way for minor update
Previous:From: Thomas PapkeDate: 2007-02-13 17:37:23
Subject: Question to safe way for minor update

Privacy Policy | About PostgreSQL
Copyright © 1996-2015 The PostgreSQL Global Development Group