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 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 по дате отправления: