[ADMIN] Question to safe way for minor update

2007-02-13 Thread Thomas Papke
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

Re: [ADMIN] Question to safe way for minor update

2007-02-13 Thread Thomas Papke
postgres version? Thomas 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

Re: [ADMIN] Question to safe way for minor update

2007-02-13 Thread Thomas Papke
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