Postgres Pro
Downloads
Home   >   mailing lists

Re: Postgres error when adding new page - Mailing list pgsql-general

From Marco Craveiro
Subject Re: Postgres error when adding new page
Date
Msg-id CAKRNd4wmyOpYkHmEDoHk4A27U0bGZLpEZkzmzFUrafn6JXqA3Q@mail.gmail.com
Whole thread Raw
In response to Re: Postgres error when adding new page  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: Postgres error when adding new page  (Marco Craveiro <marco.craveiro@gmail.com>)
List pgsql-general
Tree view
Hello Tom,

This definitely looks like index corruption, but blaming it on the
filesystem might be premature.  I'm wondering if this could be an
artifact of the WAL-replay bug fixed in 9.1.6.  I'd suggest updating
and then reindexing the index ...


We are running 9.1.2 it seems:

select version();
                                                                version                                                                 
----------------------------------------------------------------------------------------------------------------------------------------
 PostgreSQL 9.1.2 on x86_64-apple-darwin, compiled by i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5666) (dot 3), 64-bit

We'll look into upgrading to 9.1.6.

Cheers 

Marco
--
So young, and already so unknown -- Pauli

blog: http://mcraveiro.blogspot.com

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgres error when adding new page
Next
From: "Carrington, Matthew (Produban)"
Date:
Subject: Re: pg_upgrade: out of memory