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

Hi Michael, Alvaro, Tom: Really appreciate yours help, this is an invalid report, and I'm sorry for that. After I examine restart script, I found we generate recovery.conf every time, and this cause lost of timeline. Thanks. 2018-03-14 23:29 GMT+08:00 Tom Lane : > Alvaro

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

On Wed, Mar 14, 2018 at 02:12:47PM +0800, 彭昱傑 wrote: > It's useful information for me. Once archived, there is no need to keep them in the data folder as if needed at recovery the startup process would look for timeline history files where necessary if it needs to do a timeline jump. > I will

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. > > > >

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