Corrupt database
От | Neil Fraser |
---|---|
Тема | Corrupt database |
Дата | |
Msg-id | 3DAD2F9A.2070203@digitalroutes.co.uk обсуждение исходный текст |
Ответы |
Re: Corrupt database
Re: Corrupt database |
Список | pgsql-general |
One of our PostgreSQL databases has been corrupted somehow. Whenever we try to open it or access it the 'postmaster' task suddenly goes to 99% CPU usage, it rapidly eats up all memory, then crashes our server. This behaviour occurs when the database is opened in using Perl's DBI, or when using psql or pg_dump or vacuumdb. There is about a megabyte of text contained in this database which I'd rather like to extract somehow. Our other PostgreSQL databases are running perfectly. Any suggestions on how to recover my data? I've browsed the PG data files, but they appear to be binary, which I can't read. PostgreSQL 7.1.1 on Linux 2.2.19 Thank you. -- | Neil D. Fraser, Programmer & Wizard, neil@digitalroutes.co.uk | Digital Routes, Inverness, Scotland, www.digitalroutes.co.uk
В списке pgsql-general по дате отправления: