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
Thanks a lot for answer,
pgsql-admin by date
|Next:||From: Peter Eisentraut||Date: 2007-02-13 20:11:23|
|Subject: Re: Question to safe way for minor update|
|Previous:||From: gpio Oxxce||Date: 2007-02-13 17:19:27|
|Subject: possible Bug in windows version ?|