Thread: Question to safe way for minor update
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
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 over the new one. > How riskful is an minor update for the data files? Not riskful. > 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? I don't think anyone has ever seriously considered building with anything less than -O2 for anything but debugging purposes or coping with buggy compilers on rare architectures. In other words, there isn't any good reason not to do it. -- Peter Eisentraut http://developer.postgresql.org/~petere/
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 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 it, install the old one over the new one. > >> How riskful is an minor update for the data files? > > Not riskful. > >> 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? > > I don't think anyone has ever seriously considered building with > anything less than -O2 for anything but debugging purposes or coping > with buggy compilers on rare architectures. In other words, there > isn't any good reason not to do it. > > -- > Peter Eisentraut > http://developer.postgresql.org/~petere/ > > ---------------------------(end of broadcast)--------------------------- > TIP 1: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@postgresql.org so that your > message can get through to the mailing list cleanly > >
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 anecdotal evidence suggests that this combination will not work. In general, the data file compatibility is determined by some combination of architecture and compiler settings. -- Peter Eisentraut http://developer.postgresql.org/~petere/
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:
Thanks a lot,
Thomas
Peter Eisentraut schrieb:
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 over the new one.How riskful is an minor update for the data files?Not riskful.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?I don't think anyone has ever seriously considered building with anything less than -O2 for anything but debugging purposes or coping with buggy compilers on rare architectures. In other words, there isn't any good reason not to do it.
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 http://developer.postgresql.org/~petere/