Re: Limiting the no. of logs file generated by postgreSQL - Mailing list pgsql-admin

From merina ghoghwani
Subject Re: Limiting the no. of logs file generated by postgreSQL
Date
Msg-id CAKoQ0XH5Sf1vpXdA_SgLsRFb=cYXvGAJexRY3N_aEcHjgEDgoQ@mail.gmail.com
Whole thread Raw
In response to Re: Limiting the no. of logs file generated by postgreSQL  ("David G. Johnston" <david.g.johnston@gmail.com>)
List pgsql-admin
Thanks, all.

I will then explore other utilities to achieve this.

On Thu, Feb 15, 2018 at 8:28 PM, David G. Johnston <david.g.johnston@gmail.com> wrote:
On Thu, Feb 15, 2018 at 4:54 AM, merina ghoghwani <merinaghoghwani@gmail.com> wrote:
Hi All,

I am currently using PostgreSQL 9.4.5. 


​Not that it changes the answer here but you are considerably out-of-date and should upgrade to 9.4.16 as the earliest opportunity.
 

What I've observed is, 
1. I get a new file after every 10 Mins or when I restart the service or logs size is over 10KB. 

But, it doesn't solve my problem to reduce the size of postgres logs, as the file is not rotated, but a new is created every time.

Is there any way I can rotate the files or restrict number to, say max 5 files
like,


​The docs cover what can and cannot be done.  My reading indicates that what you described cannot be done - since you want to key off of size instead of time.

My conclusion is that you need to turn over log file management to an external utility - syslog, logrotate, etc..., that provides the feature you desire.

David J.



--
Regards,
Merina Ghoghwani

pgsql-admin by date:

Previous
From: Azimuddin Mohammed
Date:
Subject: Re: postgres not starting
Next
From: Guillaume Lelarge
Date:
Subject: Re: Migrate streaming replication 9.4 to 9.6