Subject: Re: current log file removal
To: pgsql-admin@lists.postgresql.org
References: 
 <CALhHtcAyBC9PsQDb-h1LaCetV85JPH7o4Md6T7_Qh0hd-6sk1Q@mail.gmail.com>
 <a0b34226-3b66-44bd-c2da-ae0ef3b32100@jakobs.com>
From: Ron <ronljohnsonjr@gmail.com>
Message-ID: <53a8b79d-6031-45d8-b213-028183750251@gmail.com>
Date: Thu, 26 Nov 2020 11:25:50 -0600
User-Agent: Mozilla/5.0 (X11; Linux x86_64; rv:68.0) Gecko/20100101
 Thunderbird/68.10.0
MIME-Version: 1.0
In-Reply-To: <a0b34226-3b66-44bd-c2da-ae0ef3b32100@jakobs.com>
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit
Content-Language: en-US
Precedence: bulk

I set these values in postgresql.conf, then have a cron job which runs just 
after midnight that compresses yesterday's log files. That same cron job 
deletes compressed files older than X days.

log_destination = 'stderr'
logging_collector = on
log_directory = '/your/data/location/12/pg_log' # assuming v12, of course
log_filename = 'postgresql-%F.log'
log_rotation_age = 1d

On 11/26/20 8:03 AM, Holger Jakobs 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
>

-- 
Angular momentum makes the world go 'round.