Re: [BUGS] BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342

2011-03-17 Thread Tambet Matiisen
On 16.03.2011 22:29, Kevin Grittner wrote: Tambet Matiisen wrote: Yes, I use pg_dump on live server and the result is rdiff-backupped into development server. Whole SQL dump is 12G without compression and the rdiff delta is about 10-20MB every day. Then I drop pre-live database on development

Re: [BUGS] BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342

2011-03-17 Thread Tambet Matiisen
On 16.03.2011 17:09, Kevin Grittner wrote: Tambet Matiisen wrote: Pre-live database is restored from live database dump every night. How is that done? A single pg_dump of the entire live database restored using psql? Are both database servers at the same PostgreSQL version? Yes, I use

Re: [BUGS] BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342

2011-03-16 Thread Tambet Matiisen
few hours. But how do I eliminate the software RAID driver? PostgreSQL has always been solid for me, so I suspect it least, but you never know... Now, off to buy UPS... Tambet On 15.03.2011 19:47, Kevin Grittner wrote: "Tambet Matiisen" wrote: For a few days I've been gett

[BUGS] BUG #5929: ERROR: found toasted toast chunk for toast value 260340218 in pg_toast_260339342

2011-03-15 Thread Tambet Matiisen
The following bug has been logged online: Bug reference: 5929 Logged by: Tambet Matiisen Email address: tambet.matii...@gmail.com PostgreSQL version: 8.4.7 Operating system: PostgreSQL 8.4.7 on i486-pc-linux-gnu, compiled by GCC gcc-4.4.real (Debian 4.4.5-10) 4.4.5, 32-bit