On Mon, Apr 18, 2011 at 3:38 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > On Sun, Apr 17, 2011 at 11:19 PM, Phoenix Kiula <phoenix.kiula@xxxxxxxxx> wrote: >> Btw, hardware is not an issue. My db has been working fine for a >> while. Smaller poorer systems around the web run InnoDB databases. I >> wouldn't touch that with a barge pole. >> >> I have a hardware RAID controller, not "fake". It's a good quality >> battery-backed 3Ware: >> http://192.19.193.26/products/serial_ata2-9000.asp > > (please stop top posting) > > Also, when you run top and hit c what do those various postgres > processes say they're doing? bgwriter, SELECT, VACUMM etc? > Thanks. But let me do the "top" stuff later. I think I have a bigger problem now. While doing a PG dump, I seem to get this error: ERROR: invalid memory alloc request size 4294967293 Upon googling, this seems to be a data corruption issue! 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 to restore from here, would I simply copy the files from the data folder back to the new install or something? Cant find these steps in the PG documentation. I'm on PG 8.2.9, CentOS 5, with 8GB of RAM. -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
