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.
> Laurenz Albe
> Cybertec | https://www.cybertec-postgresql.com