Subject: Re: STDERR not logging after a fix log size
To: still Learner <stilllearner23@gmail.com>
Cc: pgsql-admin <pgsql-admin@postgresql.org>
References: 
 <CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com>
From: MichaelDBA <MichaelDBA@sqlexec.com>
Message-ID: <9f6ccc33-05a6-1f26-9d50-5d5b1d06a025@sqlexec.com>
Date: Fri, 18 Jun 2021 06:44:15 -0400
User-Agent: Mozilla/5.0 (Windows NT 10.0; WOW64; rv:52.0) Gecko/20100101
 PostboxApp/7.0.48
MIME-Version: 1.0
In-Reply-To: 
 <CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com>
Content-Type: multipart/alternative;
 boundary="------------5C7B27ADA93C4C3CAFCE5A6D"
Content-Language: en-US
Archived-At: 
 <https://www.postgresql.org/message-id/9f6ccc33-05a6-1f26-9d50-5d5b1d06a025%40sqlexec.com>
Precedence: bulk

This is a multi-part message in MIME format.
--------------5C7B27ADA93C4C3CAFCE5A6D
Content-Type: text/plain; charset=utf-8; format=flowed
Content-Transfer-Encoding: 8bit

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.
>


--------------5C7B27ADA93C4C3CAFCE5A6D
Content-Type: text/html; charset=utf-8
Content-Transfer-Encoding: 8bit

<html theme="default" iconset="color"><head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
</head><body text="#000000">You probaby did this, but just to make sure,
 did you reload the cluster to effect the changes?<br>
<br>
Regards,<br>
Michael Vitale<br>
<br>
<span>still Learner wrote on 6/18/2021 5:02 AM:</span><br>
<blockquote type="cite" 
cite="mid:CAB3gP9+RQ3EdBCnW6JCmGL6vh+SnkD0kQwuD8pvLTE7ogEpZfw@mail.gmail.com">
  <meta http-equiv="content-type" content="text/html; charset=utf-8">
  <div dir="ltr">Hi There,<div><br></div><div>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.</div><div><br></div><div>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.</div><div><br></div><div>FYI
 ... please check below file stats and the log parameters.</div><div><br></div><div>postgres=#
 select version();<br>                                   version        
                           <br>-----------------------------------------------------------------------------<br> PostgreSQL
 11.9 on x86_64-pc-linux-gnu, compiled by gcc (GCC) 5.5.0, 64-bit<br>(1 
row)<br></div><div><br></div><div>ps -ef|grep logger<br>postgres  16765 
 16763  0 May15 ?        00:13:33 postgres: logger</div><div> <br></div><div><b>-rw-------
 1 postgres postgres  32885638 Jun  9 07:04 
postgresql-2021-06-09_000000.log</b><br><b>-rw------- 1 postgres 
postgres  10765412 Jun  9 23:59 postgresql-2021-06-09_214301.log<br>-rw-------
 1 postgres postgres 114219472 Jun 11 00:00 
postgresql-2021-06-10_000000.log<br></b>-rw------- 1 postgres postgres 
106193384 Jun 11 23:59 postgresql-2021-06-11_000000.log<br>-rw------- 1 
postgres postgres 103008728 Jun 12 23:59 
postgresql-2021-06-12_000000.log<br>-rw------- 1 postgres postgres 
104213596 Jun 14 00:00 postgresql-2021-06-13_000000.log<br>-rw------- 1 
postgres postgres 109578809 Jun 14 23:59 
postgresql-2021-06-14_000000.log<br><b>-rw------- 1 postgres postgres 
 30847172 Jun 15 08:02 postgresql-2021-06-15_000000.log<br></b>-rw-------
 1 postgres postgres  32452541 Jun 16 06:22 
postgresql-2021-06-16_000000.log<br>-rw------- 1 postgres postgres 
 31439856 Jun 17 06:20 postgresql-2021-06-17_000000.log<br>-rw------- 1 
postgres postgres  30859375 Jun 18 06:23 
postgresql-2021-06-18_000000.log<br></div><div><br></div><div><br></div><div> log_autovacuum_min_duration
    1s<br> <br> log_destination                stderr                    
                                                                        
      <br><br> log_directory 		        log                              
                                                                        
                                                        <br> log_error_verbosity
            default                                                      
                                           <br>                         
      <br> log_file_mode		        0600                                  
                                                                  <br>   
                             <br> log_filename                   
postgresql-%Y-%m-%d_%H%M%S.log                                          
                                         <br> log_line_prefix            
    %t [%p]: [%h] [%l-1] user=%u,db=%d                                  
                                                   <br> log_min_duration_statement
     2s                                                                 
                                                              <br> log_min_messages
               warning                                                  
                                              <br> log_rotation_age      
         1d                                                              
                                        <br>                             
  <br> log_rotation_size              700MB                              
                                                                     <br> 
                              <br> log_truncate_on_rotation      off   
  </div><div><span style="background-color:transparent">                 
                                                          </span><span 
style="background-color:transparent">                          </span></div><div> logging_collector
             on   <br></div><div><br></div><div>Please assist me if I 
had missed any.</div><div><br></div></div>
</blockquote>
<br>
</body></html>

--------------5C7B27ADA93C4C3CAFCE5A6D--