Too many .history file in pg_xlog takes lots of space

Hi team, My postgre version is 9.4.9, and I face a space issue. Every time I restart postgre server, it generates a new history file: 156A.history => 156B.history Now it takes a lot of space about 800MB (5787 history file): -rw--- 1 pgsql pgsql 247K Mar 13 14:49 1568.history

Re: Too many .history file in pg_xlog takes lots of space

Thank you. It's useful information for me. I will examine my restart script, and study point-in-time-recovery. Also remove unused history file. 2018-03-14 13:56 GMT+08:00 Laurenz Albe : > 彭昱傑 wrote: > > My postgre version is 9.4.9, and I face a space issue. > > >

Re: Too many .history file in pg_xlog takes lots of space

writes: > > 彭昱傑 wrote: > >> Every time I restart postgre server, it generates a new history file: > > > That's strange -- it shouldn't happen ... sounds like you're causing a > > crash each time you restart. Are you using immediate mode in shutdown >