472,783 Members | 888 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 472,783 software developers and data experts.

toast values

when I try to do a dump

pg_dump -v -f dump.dmp dtbtransporte

i get following error:

DEBUG: database system was shut down at 2003-08-08 09:40:10 BRT

DEBUG: checkpoint record is at 6/7E2E3D9C

DEBUG: redo record is at 6/7E2E3D9C; undo record is at 0/0; shutdown TRUE

DEBUG: next transaction id: 4153723; next oid: 7794648

DEBUG: database system is ready

ERROR: unexpected chunk number 8 (expected 0) for toast value 6935693

DEBUG: pq_flush: send() failed: Broken pipe

how could I fix it

I already reindexed system table (Ive started postgres standalone and did REINDEX DATABASE dtbtransporte FORCE).



Nov 11 '05 #1
0 1354

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

by: TomT | last post by:
As per subject... Does anyone know how to convert a Toast 1.6 forum (ASP) to a php based forum like phpbb2 ?? The current forum has 280+ members, and 0000's of posts... Thanks
by: Steve Hall | last post by:
Folks, My secnario involves two tables - ObservationRegister, and Person. ObservationRegister contains most of the "useful" fields, including the UserID of the person that raised the record, and...
by: Diogo Biazus | last post by:
Hi, can anyone help me with this error: ERROR: missing chunk number 0 for toast value 14227980 Is there a solution? -- Diogo Biazus diogob@gmail.com http://www.postgresql.org.br
by: Steve Crawford | last post by:
I tried to truncate a table and received the following error: "expected both swapped tables to have TOAST tables". Googling provided no insight. What does it mean? Version 7.4.1. Note: I...
by: cipher | last post by:
I have some constant values in my web service that my client application will require. Having to keep server side and client side definitions insync is tedious. I am trying to do something like...
by: Hennie | last post by:
I apologise if this is a stupid question, but I would appreciated any help on this subject. I want to create a view (VIEW_1 in example below) where I take numeric values from a field in one...
by: Neal E. Coombes | last post by:
{ Edits: manually reformatted text per request of the poster. -mod/aps } Toast is a general purpose C++ library that is lightly inspired by Boost and the Standard Library. It is where a handful...
by: gigonomics | last post by:
Hi all, I hope someone can help me out. I need to return the best available seats subject to the constraint that the seats are side by side (or return X consecutive records from a table column...
by: erikbower65 | last post by:
Using CodiumAI's pr-agent is simple and powerful. Follow these steps: 1. Install CodiumAI CLI: Ensure Node.js is installed, then run 'npm install -g codiumai' in the terminal. 2. Connect to...
by: erikbower65 | last post by:
Here's a concise step-by-step guide for manually installing IntelliJ IDEA: 1. Download: Visit the official JetBrains website and download the IntelliJ IDEA Community or Ultimate edition based on...
by: Taofi | last post by:
I try to insert a new record but the error message says the number of query names and destination fields are not the same This are my field names ID, Budgeted, Actual, Status and Differences ...
by: DJRhino1175 | last post by:
When I run this code I get an error, its Run-time error# 424 Object required...This is my first attempt at doing something like this. I test the entire code and it worked until I added this - If...
by: Rina0 | last post by:
I am looking for a Python code to find the longest common subsequence of two strings. I found this blog post that describes the length of longest common subsequence problem and provides a solution in...
by: DJRhino | last post by:
Private Sub CboDrawingID_BeforeUpdate(Cancel As Integer) If = 310029923 Or 310030138 Or 310030152 Or 310030346 Or 310030348 Or _ 310030356 Or 310030359 Or 310030362 Or...
by: lllomh | last post by:
Define the method first this.state = { buttonBackgroundColor: 'green', isBlinking: false, // A new status is added to identify whether the button is blinking or not } autoStart=()=>{
by: Mushico | last post by:
How to calculate date of retirement from date of birth
by: DJRhino | last post by:
Was curious if anyone else was having this same issue or not.... I was just Up/Down graded to windows 11 and now my access combo boxes are not acting right. With win 10 I could start typing...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.