Re: STDERR not logging after a fix log size

From: still Learner <stilllearner23(at)gmail(dot)com>
To: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
Cc: pgsql-admin <pgsql-admin(at)postgresql(dot)org>
Subject: Re: STDERR not logging after a fix log size
Date: 2021-06-18 13:46:04
Message-ID: CAB3gP9+pTSLnJ6LD_S7QdajxBNL9OB=UCpc-aYzyYJy4Rr5Lgg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Jun 18, 2021 at 6:31 PM Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
wrote:

> On Fri, 2021-06-18 at 14:32 +0530, still Learner wrote:
> > 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.
> >
> > -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
>
> That looks just like you want.
>
> The log file never reached the size limit, so it never rotated.
>
> No, its not. It is from a busy server and generates the log on whole day.
As I said when I set log_destination to Syslog, I can see the live log.
For stderr its not, even the syntactical errors are also not logged.

> Yours,
> Laurenz Albe
> --
> Cybertec | https://www.cybertec-postgresql.com

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message abbas alizadeh 2021-06-18 14:33:08 Re: Kill postgresql process
Previous Message Laurenz Albe 2021-06-18 13:01:20 Re: STDERR not logging after a fix log size