Re: temporary data after diskspace error

Поиск
Список
Период
Сортировка
От Willy-Bas Loos
Тема Re: temporary data after diskspace error
Дата
Msg-id CAHnozTjyEodb+gu3joijHR15uCsW+x9fgHGYTxkn_heYPOzJhw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: temporary data after diskspace error  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: temporary data after diskspace error
Список pgsql-general
Дерево обсуждения
Ok, thanks everyone!
Will there be a lot of downtime to delete those 90GB of temp files?

Will postgres just delete those files without processing them or should I brace for some downtime?


Op ma 27 jan. 2020 17:15 schreef Tom Lane <tgl@sss.pgh.pa.us>:
Willy-Bas Loos <willybas@gmail.com> writes:
> And also: How can i make postgres clean up the files?
> Can it be done without restarting the cluster?
> Will restarting it help?

A restart will clean out temp files.  I don't think there's any
terribly safe way to do it without that.  You could manually
remove such files that haven't been accessed recently, but the
risk of human error is high.

                        regards, tom lane

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

Предыдущее
От: Michael Lewis
Дата:
Сообщение: Re: temporary data after diskspace error
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: PostgresSQL 10 on remote server - Socket is not connected(0x00002749/10057)