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

Question to safe way for minor update

From: "Thomas Papke" <tp(at)thopap(dot)de>
To: pgsql-admin(at)postgresql(dot)org
Subject: Question to safe way for minor update
Date: 2007-02-13 17:37:23
Message-ID: 1001305.61140.62.214.193.211.1171388243.squirrel@webmailer.hosteurope.de (view raw or flat)
Thread:
Lists: pgsql-admin
Hello,

two questions regarding postgres installation:

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)?
Installation in a separate directory?
--> maybe i could compile it with installation path to
/usr/local/pgsql/current , but current is an symbolic link to the actual
version 8.1.8 - and i could jump back to the old version. Any problems
here? During install i have defined the --prefix to
"/usr/local/pgsql/current -  during make install -> could i set this to
/usr/local/pgsql/8.1.8 and later set the symlink of current?

How riskful is an minor update for the data files?

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?

Thanks a lot for answer,
Thomas

Responses

pgsql-admin by date

Next:From: Peter EisentrautDate: 2007-02-13 20:11:23
Subject: Re: Question to safe way for minor update
Previous:From: gpio OxxceDate: 2007-02-13 17:19:27
Subject: possible Bug in windows version ?

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