[ADMIN] ERROR: could not access status of transaction

2011-03-24 Thread Stevie
Hello pgsql-admins, we have a problem with our Postgresql 9.0.3 backup database (Ubuntu 10.4). The backup and restore is done as described here: http://www.postgresql.org/docs/9.0/static/continuous-archiving.html If you want to know the exact steps of backup and restore,please ask. We restore the

Re: [ADMIN] ERROR: could not access status of transaction

2011-03-25 Thread Stevie
Hello > There is a commit log corruption in your database. Yes, and it seems this is produce by a pg_upgrade bug from pg8 to pg9 in October 2010. > You need to make the files with right size (256K of zeroes).A suitable > "dd" from /dev/zero will accomplish this on modernUnixen (ie, anything > t