pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
Question to safe way for minor update
6+ messages / 2 participants
[nested] [flat]

* Question to safe way for minor update
@ 2007-02-13 17:37 Thomas Papke <tp@thopap.de>
  2007-02-13 20:11 ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 1 reply; 6+ messages in thread

From: Thomas Papke @ 2007-02-13 17:37 UTC (permalink / raw)
  To: pgsql-admin

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



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Question to safe way for minor update
  2007-02-13 17:37 Question to safe way for minor update Thomas Papke <tp@thopap.de>
@ 2007-02-13 20:11 ` Peter Eisentraut <peter_e@gmx.net>
  2007-02-13 21:08   ` Re: Question to safe way for minor update Thomas Papke <tp@thopap.de>
  2007-02-14 06:55   ` Re: Question to safe way for minor update Thomas Papke <tp@thopap.de>
  0 siblings, 2 replies; 6+ messages in thread

From: Peter Eisentraut @ 2007-02-13 20:11 UTC (permalink / raw)
  To: pgsql-admin; +Cc: Thomas Papke <tp@thopap.de>

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/



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Question to safe way for minor update
  2007-02-13 17:37 Question to safe way for minor update Thomas Papke <tp@thopap.de>
  2007-02-13 20:11 ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
@ 2007-02-13 21:08   ` Thomas Papke <tp@thopap.de>
  2007-02-13 23:34     ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
  1 sibling, 1 reply; 6+ messages in thread

From: Thomas Papke @ 2007-02-13 21:08 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin@postgresql.org, "Thomas Papke" <tp@thopap.de>

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
>
>




^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Question to safe way for minor update
  2007-02-13 17:37 Question to safe way for minor update Thomas Papke <tp@thopap.de>
  2007-02-13 20:11 ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
  2007-02-13 21:08   ` Re: Question to safe way for minor update Thomas Papke <tp@thopap.de>
@ 2007-02-13 23:34     ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 6+ messages in thread

From: Peter Eisentraut @ 2007-02-13 23:34 UTC (permalink / raw)
  To: Thomas Papke <tp@thopap.de>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Question to safe way for minor update
  2007-02-13 17:37 Question to safe way for minor update Thomas Papke <tp@thopap.de>
  2007-02-13 20:11 ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
@ 2007-02-14 06:55   ` Thomas Papke <tp@thopap.de>
  2007-02-14 07:33     ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
  1 sibling, 1 reply; 6+ messages in thread

From: Thomas Papke @ 2007-02-14 06:55 UTC (permalink / raw)
  To: Peter Eisentraut <peter_e@gmx.net>; +Cc: pgsql-admin

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. 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.
>
>  
>

^ permalink  raw  reply  [nested|flat] 6+ messages in thread

* Re: Question to safe way for minor update
  2007-02-13 17:37 Question to safe way for minor update Thomas Papke <tp@thopap.de>
  2007-02-13 20:11 ` Re: Question to safe way for minor update Peter Eisentraut <peter_e@gmx.net>
  2007-02-14 06:55   ` Re: Question to safe way for minor update Thomas Papke <tp@thopap.de>
@ 2007-02-14 07:33     ` Peter Eisentraut <peter_e@gmx.net>
  0 siblings, 0 replies; 6+ messages in thread

From: Peter Eisentraut @ 2007-02-14 07:33 UTC (permalink / raw)
  To: Thomas Papke <tp@thopap.de>; +Cc: pgsql-admin

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/



^ permalink  raw  reply  [nested|flat] 6+ messages in thread


end of thread, other threads:[~2007-02-14 07:33 UTC | newest]

Thread overview: 6+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2007-02-13 17:37 Question to safe way for minor update Thomas Papke <tp@thopap.de>
2007-02-13 20:11 ` Peter Eisentraut <peter_e@gmx.net>
2007-02-13 21:08   ` Thomas Papke <tp@thopap.de>
2007-02-13 23:34     ` Peter Eisentraut <peter_e@gmx.net>
2007-02-14 06:55   ` Thomas Papke <tp@thopap.de>
2007-02-14 07:33     ` Peter Eisentraut <peter_e@gmx.net>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox