Re: Please help with this error message

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: Please help with this error message
Дата
Msg-id 20030331082804.F9801@mail.libertyrms.com
обсуждение исходный текст
Ответ на Re: Please help with this error message  ("Chris Smith" <cdsmith@twu.net>)
Список pgsql-general
On Fri, Mar 28, 2003 at 03:48:00PM -0700, Chris Smith wrote:

> pg_dump doesn't work.  Our SA copied the files, and all testing seems to
> indicate that the database is working just the same on the new server as the
> old location.

Even more, then, I suspect the original server.  If bad data made it
in such that you can't COPY it out, then it'll be bad everywhere you
go.

What you need to do is figure out what table it's on and what
record(s) it is.  I think you might want to try playing with
pg_filedump to get some ideas.  If all else fails, you can get the
data on either side of it by SORTing from the top of the table and
the bottom.  You can then select all that into a file, and put it
into a freshly-created table.  Not ideal, but it'll get you there.
Others will undoubtedly have more elegant solutions.

By the way, the potential for inserting bad records is one reason we
always specify ECC RAM for database machines.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


В списке pgsql-general по дате отправления:

Предыдущее
От: john.murdoch@ig.com.br
Дата:
Сообщение: PGSTAT error
Следующее
От: Hervé Piedvache
Дата:
Сообщение: Re: [Pgreplication-general] DBMIRROR and INSERT transactions lose time ...