Re: Logging

From: Stephen Eilert <contact(at)stepheneilert(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org, Rich Shepard <rshepard(at)appl-ecosys(dot)com>
Subject: Re: Logging
Date: 2019-12-04 23:24:41
Message-ID: 852cbe6a-fb10-4132-b909-0771b3ed9b1b@Spark
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Usually, this is done by logrotate or a similar mechanism in your system. You’ll likely find that other logs in your system follow a similar pattern, not just Postgresql.

— Stephen
On Dec 4, 2019, 3:21 PM -0800, Rich Shepard <rshepard(at)appl-ecosys(dot)com>, wrote:
> Running Slackware-14.2/x86_64 and postgresql-11.5.
>
> In /var/log/ are these files:
>
> -rw-r----- 1 postgres wheel 0 Nov 23 04:40 postgresql-11
> -rw-r----- 1 postgres wheel 723 Nov 23 04:40 postgresql-11.1
> -rw-r----- 1 postgres wheel 324 Nov 20 04:40 postgresql-11.2.gz
> -rw-r----- 1 postgres wheel 320 Nov 17 04:40 postgresql-11.3.gz
> -rw-r----- 1 postgres wheel 322 Nov 14 04:40 postgresql-11.4.gz
> -rw-r----- 1 postgres wheel 321 Nov 10 04:40 postgresql-11.5.gz
> -rw-r----- 1 postgres wheel 325 Nov 6 04:40 postgresql-11.6.gz
> -rw-r----- 1 postgres wheel 337 Oct 23 04:40 postgresql-11.7.gz
>
> I assume that they're an automatic backup that runs every 3-4 days. What's
> backed up and where is this controlled?
>
> I ask because I have a cron job that does a pg_dumpall each night at 11:30
> pm. (It's a small installation for my business use so the files are not
> excessive and I keep them for only short periods.)
>
> Regards,
>
> Rich
>
>

In response to

  • Logging at 2019-12-04 23:20:59 from Rich Shepard

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2019-12-04 23:26:24 Re: Logging
Previous Message Rich Shepard 2019-12-04 23:20:59 Logging