Re: [ADMIN] pg_clog after crash

2004-06-14 Thread Tom Lane
Andreas Schmitz <[EMAIL PROTECTED]> writes: >> What PG version is this? > PostgreSQL 7.4.1 is used in this case. Now that I look at it, your report matches Chris K-L's trouble http://archives.postgresql.org/pgsql-hackers/2004-01/msg00530.php which is fixed in 7.4.2. regar

Re: [ADMIN] pg_clog after crash

2004-06-14 Thread Andreas Schmitz
Hi Tom, PostgreSQL 7.4.1 is used in this case. I was able to fix the clog by dd if=/dev/zero bs=8k count=1 >> Andreas Schmitz <[EMAIL PROTECTED]> writes: > > after a harddisk filling up to a 100% the database crashed. This is > > the output I get when I try to start the DB again. Is there any ch

Re: [ADMIN] pg_clog after crash

2004-06-11 Thread Tom Lane
Andreas Schmitz <[EMAIL PROTECTED]> writes: > after a harddisk filling up to a 100% the database crashed. This is > the output I get when I try to start the DB again. Is there any chance > to get it back running without using a dump ? What PG version is this? regards, tom

[ADMIN] pg_clog after crash

2004-06-11 Thread Andreas Schmitz
Hello *, after a harddisk filling up to a 100% the database crashed. This is the output I get when I try to start the DB again. Is there any chance to get it back running without using a dump ? regards, -Andreas 2004-06-11 13:38:23 [22379] LOG: database system was interrupted while in r