| From: | Marco Craveiro <marco(dot)craveiro(at)gmail(dot)com> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Postgres error when adding new page |
| Date: | 2012-10-01 14:49:35 |
| Message-ID: | CAKRNd4wmyOpYkHmEDoHk4A27U0bGZLpEZkzmzFUrafn6JXqA3Q@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Carrington, Matthew (Produban) | 2012-10-01 14:50:41 | Re: pg_upgrade: out of memory |
| Previous Message | Tom Lane | 2012-10-01 14:42:02 | Re: Postgres error when adding new page |