When I renamed log file, there was no new one created, do I need to reload postgres?
regards
On Thu, Nov 26, 2020 at 4:03 PM Holger Jakobs <holger@jakobs.com> wrote:
The ordinary log rotation should do.
These are the default settings (therefore commented with a # in postgresql.conf):
#log_rotation_age = 1d # Automatic rotation of logfiles will # happen after that time. 0 disables. #log_rotation_size = 10MB # Automatic rotation of logfiles will # happen after that much log output. # 0 disables.
So your log files will not exceed 10 MB.
Of course, you can to this manually as well. Just rename the current logfile, a new one will be created.
Then gzip or bzip2 or xz the old one.
Am 26.11.20 um 14:40 schrieb Yambu: > Hi > > How can I safely remove the log file that is being used currently and > zip it without interfering with the postgres server? > > We are running out of space on the server and the logs are eating a > lot of space, we need to zip them without first stopping the server. > > regards