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
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
Thank you,
Then i'll try something like this for configure:
./configure CFLAGS='-march=opteron -O2 -pipe'
AN other question: Are the postgres datafiles (not the dump) platform
independ? So is it possible to just copy the datafiles from linux to a
windows machine if they are running the same
Thomas Papke wrote:
AN other question: Are the postgres datafiles (not the dump) platform
independ?
No.
So is it possible to just copy the datafiles from linux to
a windows machine if they are running the same postgres version?
There is no guarantee or direct check against this, but
Right now our 8.1.4 is running without any compiler options. Any
possible problem if i will compile the 8.1.8 with CLAGS -O2
-march=Opteron -- will the datafiles of the 8.1.4 non optimized
postgres make any problems?
Thanks a lot,
Thomas
Peter Eisentraut schrieb:
Thomas Papke wrote:
1.
Thomas Papke wrote:
Right now our 8.1.4 is running without any compiler options. Any
possible problem if i will compile the 8.1.8 with CLAGS -O2
-march=Opteron -- will the datafiles of the 8.1.4 non optimized
postgres make any problems?
No.
--
Peter Eisentraut
