From: | Phoenix Kiula <phoenix(dot)kiula(at)gmail(dot)com> |
---|---|
To: | PG-General Mailing List <pgsql-general(at)postgresql(dot)org> |
Subject: | Help - corruption issue? |
Date: | 2011-04-18 05:52:01 |
Message-ID: | BANLkTi=HunDRp5GS1TaZBrYrQ=zf3YazCQ@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
While doing a PG dump, I seem to have a problem:
ERROR: invalid memory alloc request size 4294967293
Upon googling, this seems to be a data corruption issue!
( Came about while doing performance tuning as being discussed on the
PG-PERFORMANCE list:
http://postgresql.1045698.n5.nabble.com/REINDEX-takes-half-a-day-and-still-not-complete-td4005943.html
)
One of the older messages suggests that I do "file level backup and
restore the data".
http://archives.postgresql.org/pgsql-admin/2008-05/msg00191.php
How does one do this -- should I copy the data folder? What are the
specific steps?
I'm on PG 8.2.9, CentOS 5, with 8GB of RAM. The disks are four SATAII
disks on RAID 1.
Thanks!
From | Date | Subject | |
---|---|---|---|
Next Message | Chetan Suttraway | 2011-04-18 07:16:14 | Re: [GENERAL] Postgres Start up Error |
Previous Message | Adarsh Sharma | 2011-04-18 05:30:23 | Postgres Start up Error |