Re: full data disk -- any chance of recovery

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: full data disk -- any chance of recovery
Дата
Msg-id 7230.1136223929@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: full data disk -- any chance of recovery  ("Gregory S. Williamson" <gsw@globexplorer.com>)
Ответы Re: full data disk -- any chance of recovery  ("Jim C. Nasby" <jnasby@pervasive.com>)
Список pgsql-admin
"Gregory S. Williamson" <gsw@globexplorer.com> writes:
> 2006-01-02 00:30:01 LOG:  could not close temporary statistics file
"/data/postgres/gex_runtime/global/pgstat.tmp.1453":No space left on device 
> 2006-01-02 00:33:54 ERROR:  could not access status of transaction 0
> DETAIL:  could not write to file "/data/postgres/gex_runtime/pg_clog/0AFA" at offset 196608: No space left on device

Just kill -9 all the postgres processes; everything you need should be
safely down in the WAL files.

You might not have to move pg_xlog --- the first thing to do is see
if there are any large temp files hanging about in the pgsql_tmp
subdirectories.  Anything you see in there can be shot on sight once
the postmaster is stopped (actually, recent versions of the postmaster
will do it for you on restart, but don't remember about 7.4).

Which PG release is this exactly (7.4.what)?  This misbehavior reminds
me of a bug that we fixed in 7.4.2.

            regards, tom lane

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

Предыдущее
От: Jeff Frost
Дата:
Сообщение: Re: full data disk -- any chance of recovery
Следующее
От: warren little
Дата:
Сообщение: Emergency - Need assistance