Re: [GENERAL] DB crash after disk full

2005-12-29 Thread Vilen Tambovtsev
Version 8.1.1 Got to make it work, after deletin some records from table Tom Lane wrote: Vilen Tambovtsev <[EMAIL PROTECTED]> writes: - 2005-12-28 19:02:49 NOVT - - 2747: PANIC: could not access status of transaction 74678708 What Postgres version is this? regard

Re: [GENERAL] DB crash after disk full

2005-12-28 Thread Tom Lane
Vilen Tambovtsev <[EMAIL PROTECTED]> writes: > - 2005-12-28 19:02:49 NOVT - - 2747: PANIC: could not access status of > transaction 74678708 What Postgres version is this? regards, tom lane ---(end of broadcast)--- TIP

Re: [GENERAL] DB crash after disk full

2005-12-28 Thread Vilen Tambovtsev
Got to make it work, but now, when i try to make a dump it says pg_dump: SQL command failed pg_dump: Error message from server: ERROR: missing chunk number 0 for toast value 2969644 pg_dump: The command was: FETCH 100 FROM _pg_dump_cursor tried reindex: reindexdb: reindexing of database "hostel

[GENERAL] DB crash after disk full

2005-12-28 Thread Vilen Tambovtsev
Hello, My disk went out of space, so pgsql crashed, and had some FS troubles occurred. I fixed FS, then tried to start and got this: - 2005-12-28 19:02:49 NOVT - - 2747: LOG: database system was interrupted at 2005-12-28 19:02:09 NOVT - 2005-12-28 19:02:49 NOVT - - 2747: LOG: checkpoint r