From: MichaelDBA <MichaelDBA@sqlexec.com>
To: still Learner <stilllearner23@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
Subject: Re: STDERR not logging after a fix log size
Date: Fri, 18 Jun 2021 06:44:15 -0400
Message-ID: <9f6ccc33-05a6-1f26-9d50-5d5b1d06a025@sqlexec.com> (raw)
In-Reply-To: <CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com>
References: <CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com>
You probaby did this, but just to make sure, did you reload the cluster
to effect the changes?
Regards,
Michael Vitale
still Learner wrote on 6/18/2021 5:02 AM:
> Hi There,
>
> A few days back (on 9th June) I have changed my log_rotation_size to
> 30 MB and on the same day again reset to 500 MB. for few days it went
> well, from 15th June itself generating only 30MB files. Now I have
> reset to 700 MB and reloaded, still am getting the same size of log
> and the log file is also not rotating.
>
> I have tried changing the log_destination to Syslog which is logging
> in /var/log/messages however stderr not logging in to the log folder.
>
> FYI ... please check below file stats and the log parameters.
>
> postgres=# select version();
> version
> -----------------------------------------------------------------------------
> PostgreSQL 11.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 5.5.0,
> 64-bit
> (1 row)
>
> ps -ef|grep logger
> postgres 16765 16763 0 May15 ? 00:13:33 postgres: logger
>
> *-rw------- 1 postgres postgres 32885638 Jun 9 07:04
> postgresql-2021-06-09_000000.log*
> *-rw------- 1 postgres postgres 10765412 Jun 9 23:59
> postgresql-2021-06-09_214301.log
> -rw------- 1 postgres postgres 114219472 Jun 11 00:00
> postgresql-2021-06-10_000000.log
> *-rw------- 1 postgres postgres 106193384 Jun 11 23:59
> postgresql-2021-06-11_000000.log
> -rw------- 1 postgres postgres 103008728 Jun 12 23:59
> postgresql-2021-06-12_000000.log
> -rw------- 1 postgres postgres 104213596 Jun 14 00:00
> postgresql-2021-06-13_000000.log
> -rw------- 1 postgres postgres 109578809 Jun 14 23:59
> postgresql-2021-06-14_000000.log
> *-rw------- 1 postgres postgres 30847172 Jun 15 08:02
> postgresql-2021-06-15_000000.log
> *-rw------- 1 postgres postgres 32452541 Jun 16 06:22
> postgresql-2021-06-16_000000.log
> -rw------- 1 postgres postgres 31439856 Jun 17 06:20
> postgresql-2021-06-17_000000.log
> -rw------- 1 postgres postgres 30859375 Jun 18 06:23
> postgresql-2021-06-18_000000.log
>
>
> log_autovacuum_min_duration 1s
>
> log_destination stderr
>
> log_directory log
> log_error_verbosity default
>
> log_file_mode 0600
>
> log_filename postgresql-%Y-%m-%d_%H%M%S.log
> log_line_prefix %t [%p]: [%h] [%l-1] user=%u,db=%d
> log_min_duration_statement 2s
> log_min_messages warning
> log_rotation_age 1d
>
> log_rotation_size 700MB
>
> log_truncate_on_rotation off
> logging_collector on
>
> Please assist me if I had missed any.
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: MichaelDBA@sqlexec.com, stilllearner23@gmail.com
Subject: Re: STDERR not logging after a fix log size
In-Reply-To: <9f6ccc33-05a6-1f26-9d50-5d5b1d06a025@sqlexec.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox