Re: pg_xlog is getting bigger

Поиск
Список
Период
Сортировка
От Pankaj Mishra
Тема Re: pg_xlog is getting bigger
Дата
Msg-id CADgijrguDpk_Xg=XBeH2mNHtOYLJvz=QGmchT4xx1de+sg4epQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: pg_xlog is getting bigger  (Kevin Grittner <kgrittn@ymail.com>)
Ответы Re: pg_xlog is getting bigger
Re: pg_xlog is getting bigger
Список pgsql-general
Dera Kevin,

If you run checkpoint in database then you can delete the pg_xlog other then current timestamp. We do this to our customer on regular basis when pg_xlog exceed more then 15 gb
Regards
Pankaj


On Sat, Nov 23, 2013 at 1:48 AM, Kevin Grittner <kgrittn@ymail.com> wrote:
Pankaj <pankaj.mimit@gmail.com> wrote:

> now go to pg_xlog folder you can can see a pattern in file names of logs.
> Just remove the file other then current time stamp. Or for safety remove
> logs other then current date.

No!!!  NEVER remove ANY files from the pg_xlog sub-directory!  That
will corrupt your database.

--
Kevin Grittner
EDB: http://www.enterprisedb.com
The Enterprise PostgreSQL Company

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

Предыдущее
От: "Mahlon E. Smith"
Дата:
Сообщение: Re: Streaming replication slave crash
Следующее
От: Tobadao
Дата:
Сообщение: Slony-I installation Help !