Re: Can't get postmaster to restart after removing WAL files

Поиск
Список
Период
Сортировка
От Robert.Farrugia@go.com.mt
Тема Re: Can't get postmaster to restart after removing WAL files
Дата
Msg-id OFE41A1054.105B0BDC-ONC1256AC5.00475D90@go.com.mt
обсуждение исходный текст
Ответ на Can't get postmaster to restart after removing WAL files  ("Nick Fankhauser" <nickf@ontko.com>)
Ответы Re: Can't get postmaster to restart after removing WAL files  ("Nick Fankhauser" <nickf@ontko.com>)
Список pgsql-admin
You can try running pg_resetxlog (situated in the contrib directory in the
source).  It will reset the wal files and will allow you to restart the
postmaster.  It is not the recommended way but I used in in dire
emergencies and it worked.

Normally, when you fill up the drive because of WALs, you should try to
free up 16MB.  If the drive is the same as the database, you can move one
file from the database directory to another partition, create a soft link
to the file, and restart the database.  Once the WAL files are removed by
the postmaster, you should stop it, and copy back the file.  Try to upgrade
to 7.1.3 since it solves some issues where long transactions take up an
unordinated amount of space unecessary.

As regards to the space required by the WAL files this depends on the
configuration (postgresql.conf).  There is a paramter which controls the
amount of WAL files to create (each file takes 16MB).

Hope it helps
Robert



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

Предыдущее
От: Paul Green
Дата:
Сообщение: Broken index? (the revenge)
Следующее
От: "Nick Fankhauser"
Дата:
Сообщение: Re: Can't get postmaster to restart after removing WAL files