Re: current log file removal - Mailing list pgsql-admin

From Holger Jakobs
Subject Re: current log file removal
Date
Msg-id a0b34226-3b66-44bd-c2da-ae0ef3b32100@jakobs.com
Whole thread Raw
In response to current log file removal  (Yambu <hyambu@gmail.com>)
Responses Re: current log file removal
Re: current log file removal
List pgsql-admin
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

--
Holger Jakobs, Bergisch Gladbach, Tel. +49-178-9759012


Attachment

pgsql-admin by date:

Previous
From: Holger Jakobs
Date:
Subject: Re: Move base directory to different location
Next
From: Paul Förster
Date:
Subject: Re: Move base directory to different location