Re: 7.1.2 temporary file area

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: 7.1.2 temporary file area
Дата
Msg-id Pine.LNX.4.30.0106131723230.756-100000@peter.localdomain
обсуждение исходный текст
Ответ на 7.1.2 temporary file area  (Travis Bauer <trbauer@indiana.edu>)
Список pgsql-general
Travis Bauer writes:

> Here is the error I get (I changed the names of the paths listed):
>
> postmaster successfully started
> DEBUG:  database system was shut down at 2001-06-13 09:28:28 EST
> DEBUG:  CheckPoint record at (0, 12584784)
> DEBUG:  Redo record at (0, 12584784); Undo record at (0, 0); Shutdown TRUE
> DEBUG:  NextTransactionId: 2123; NextOid: 45698
> FATAL 2:  ZeroFill([a-path]/xlogtemp.7890) failed:
>       Disc quota exceeded : [path-to-executable] Startup proc 7890 exited
>       with status 512 - abort
>
> I believe postgres is creating a large temporary file.  How can I
> tell is to put the files in another temporary directory where I
> have more space?

You can't.  This temporary file is the precursor of a transaction log
file, so if your disk is full then you're out of luck anyway.  Btw., we're
talking about 16 MB here.

--
Peter Eisentraut   peter_e@gmx.net   http://funkturm.homeip.net/~peter


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

Предыдущее
От: "Thalis A. Kalfigopoulos"
Дата:
Сообщение: Re: Unique rows without a key
Следующее
От: Bruce Momjian
Дата:
Сообщение: Re: Re: Does PostgreSQL support EXISTS?