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 <laurenz.a...@cybertec.at>: > 彭昱傑 wrote: > > 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: > > 0000156A.history => 0000156B.history > > > > Now it takes a lot of space about 800MB (5787 history file): > > [...] > > Is file 00001570.history important? > > A new history file is created when a new timeline is opened, > which happens after point-in-time-recovery or promotion of > a physical standby server. > > There must be something weird in the way you start PostgreSQL. > Examine the start script, maybe you can fix the problem. > > These files are only necessary for point-in-time-recovery, > so you don't have to retain them any longer than you retain > your WAL archives. > > Yours, > Laurenz Albe > -- > Cybertec | https://www.cybertec-postgresql.com >
