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