Re: Serious Crash last Friday

From: "Henrik Steffen" <steffen(at)city-map(dot)de>
To: "pg" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Serious Crash last Friday
Date: 2002-07-09 15:33:58
Message-ID: 01a201c2275e$0cf53200$7100a8c0@topconcepts.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Hello,

I am back from vacation and still experiencing strange behaviour of my database:

Dumping all to /var/lib/pgsql/backup/db-backup-20020709.out....
connected to template1...
dumping database "kunden"...
pg_dump: ERROR: cannot open segment 1 of relation pg_toast_16584 (target block 1048595): No such file or directory
pg_dump: lost synchronization with server, resetting connection
pg_dump: SQL command to dump the contents of table "seiten" failed: PQendcopy() failed.
pg_dump: Error message from server: pg_dump: The command was: COPY "seiten" TO stdout;
pg_dump failed on kunden, exiting

This is my daily dump programm for backup reasons... tonight it didn't succeed,
and I don't understand why.

anyone ever had pg_toast for breakfast ?

any help appreciated

thanks

Mit freundlichem Gruß

Henrik Steffen
Geschäftsführer

top concepts Internetmarketing GmbH
Am Steinkamp 7 - D-21684 Stade - Germany
--------------------------------------------------------
http://www.topconcepts.com Tel. +49 4141 991230
mail: steffen(at)topconcepts(dot)com Fax. +49 4141 991233
--------------------------------------------------------
24h-Support Hotline: +49 1908 34697 (EUR 1.86/Min,topc)
--------------------------------------------------------
System-Partner gesucht: http://www.franchise.city-map.de
--------------------------------------------------------
Handelsregister: AG Stade HRB 5811 - UstId: DE 213645563
--------------------------------------------------------

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2002-07-09 15:39:47 Re: Redhat/glibc and postgre time "bug"
Previous Message Yvan Blancmunier 2002-07-09 15:32:41 MYSQL