Re: current log file removal

[Holger Jakobs <holger@xxxxxxxxxx>]

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: OpenPGP_signature
Description: OpenPGP digital signature