| From: | Rich Shepard <rshepard(at)appl-ecosys(dot)com> |
|---|---|
| To: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Logging |
| Date: | 2019-12-04 23:20:59 |
| Message-ID: | alpine.LNX.2.20.1912041517070.546@salmo.appl-ecosys.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Stephen Eilert | 2019-12-04 23:24:41 | Re: Logging |
| Previous Message | Jerry Sievers | 2019-12-04 22:31:35 | Re: what causes xact_rollback for a database in pg_stat_database to increment? |