Andrew Sullivan wrote:
>On Mon, May 15, 2006 at 10:15:13AM +0100, Gavin Hamill wrote:
>
>
>Hrm. I'd still bet on data corruption. You might try walking
>through the table, getting all the data, in chunks, and see if you
>get a failure.
>
I just did a "pg_dump -F p"of that table alone in one fell swoop, and it
worked perfectly; it's left me a nice
COPY "RoomNight" ("ID", "BookingID", "RoomID", "Price", "Date",
"DateBooked", "Cancelled", "GuestName", "Adults", "Children",
"AllocationStatusID", "SmokingRequest", "BedRequested", "Incomplete",
"RoomNumber") FROM stdin;
followed by all 800k rows .. no segfaults, no errors at all :/
>Why does this happen roughly once a day?
>
>
I'd hoped the corefile would've been able to tell me that, but seemingly
not :(
gdh
_______________________________________________
Slony1-general mailing list
[email protected]
http://gborg.postgresql.org/mailman/listinfo/slony1-general
