[ADMIN] How to upgrade PostgreSQL minor releases without a dump/restore?

2011-02-28 Thread Gnanakumar
Hi, Our production server is running PostgreSQL v8.2.3 on CentOS5.2. We're planning to upgrade to the latest version in 8.2 series, that is v8.2.20. Also, in future, we've planned to upgrade to the most recent minor release as soon as possible (as and when released by PostgreSQL). Initially, we'v

[ADMIN] Re: [HACKERS] Re: PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

2011-02-28 Thread Greg Stark
On Tue, Mar 1, 2011 at 1:43 AM, David Christensen wrote: > Was this cluster upgraded to 8.4.4 from 8.4.0?  It sounds to me like a known > bug in 8.4.0 which was fixed by this commit: > The reproduction script described was running vacuum repeatedly. A single vacuum run out to be sufficient to cl

Re: [HACKERS] Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

2011-02-28 Thread Fujii Masao
On Tue, Mar 1, 2011 at 10:43 AM, David Christensen wrote: > Was this cluster upgraded to 8.4.4 from 8.4.0?  It sounds to me like a known > bug in 8.4.0 which was fixed by this commit: > > commit 7fc7a7c4d082bfbd579f49e92b046dd51f1faf5f > Author: Tom Lane > Date:   Mon Aug 24 02:18:32 2009 +

Re: [HACKERS] Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

2011-02-28 Thread David Christensen
On Feb 28, 2011, at 3:28 PM, daveg wrote: > On Wed, Jan 12, 2011 at 10:46:14AM +0200, Heikki Linnakangas wrote: >> On 12.01.2011 06:21, Fujii Masao wrote: >>> On Sat, Dec 25, 2010 at 2:09 PM, Maxim Boguk wrote: While I trying create reproducible test case for BUG #5798 I encountered ve

Re: [HACKERS] Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

2011-02-28 Thread daveg
On Wed, Jan 12, 2011 at 10:46:14AM +0200, Heikki Linnakangas wrote: > On 12.01.2011 06:21, Fujii Masao wrote: > >On Sat, Dec 25, 2010 at 2:09 PM, Maxim Boguk wrote: > >>While I trying create reproducible test case for BUG #5798 I > >>encountered very strange effect on two of my servers (both serve

Re: [HACKERS] Re: [ADMIN] PD_ALL_VISIBLE flag was incorrectly set happend during repeatable vacuum

2011-02-28 Thread Heikki Linnakangas
On 28.02.2011 23:28, daveg wrote: On Wed, Jan 12, 2011 at 10:46:14AM +0200, Heikki Linnakangas wrote: We'll likely need to go back and forth a few times with various debugging patches until we get to the heart of this.. Anything new on this? I'm seeing at on one of my clients production boxes.

[ADMIN] Error when trying to create Database Cluster

2011-02-28 Thread Arnold, Sandra
I am running the following initdb command and get the following error. initdb -A md5 -D /pgsql/ftrp/data9 -E UTF8 --locale=C -U postgres -W initdb: error while loading shared libraries: /app/PostgreSQL/9.0/lib/libedit.so: cannot restore segment prot after reloc: Permission denied I am using the