View Issue Details
| ID | Project | Category | View Status | Date Submitted | Last Update |
|---|---|---|---|---|---|
| 0000165 | My infrastructure | General | public | 2021-07-23 22:13 | 2021-08-04 00:01 |
| Reporter | dvl | Assigned To | dvl | ||
| Priority | normal | Severity | minor | Reproducibility | have not tried |
| Status | closed | Resolution | fixed | ||
| Summary | 0000165: dbclone: check log rotation for /var/log/postgresql.log | ||||
| Description | Should be daily, it's not, since May 30.[dan@dbclone:/usr/local/etc/newsyslog.conf.d]: $ ls -lt /var/log/postgresql.log* -rw-r----- 1 postgres logcheck 10755765 Jul 23 22:09 /var/log/postgresql.log -rw-r----- 1 postgres logcheck 202203 May 30 23:00 /var/log/postgresql.log.0 -rw-r----- 1 postgres logcheck 201647 May 29 23:00 /var/log/postgresql.log.1 -rw-r----- 1 postgres logcheck 205245 May 28 23:00 /var/log/postgresql.log.2 -rw-r----- 1 postgres logcheck 191818 May 27 23:00 /var/log/postgresql.log.3 -rw-r----- 1 postgres logcheck 202859 May 26 23:00 /var/log/postgresql.log.4 -rw-r----- 1 postgres logcheck 202403 May 25 23:00 /var/log/postgresql.log.5 -rw-r----- 1 postgres logcheck 202859 May 24 23:00 /var/log/postgresql.log.6 -rw-r----- 1 postgres logcheck 201886 May 23 23:00 /var/log/postgresql.log.7 -rw-r----- 1 postgres logcheck 201943 May 22 23:00 /var/log/postgresql.log.8 -rw-r----- 1 postgres logcheck 202936 May 21 23:00 /var/log/postgresql.log.9 -rw-r----- 1 postgres logcheck 180007 May 20 23:00 /var/log/postgresql.log.10 -rw-r----- 1 postgres logcheck 201379 May 19 23:00 /var/log/postgresql.log.11 -rw-r----- 1 postgres logcheck 201488 May 18 23:00 /var/log/postgresql.log.12 -rw-r----- 1 postgres logcheck 204580 May 17 23:00 /var/log/postgresql.log.13 -rw-r----- 1 postgres logcheck 201033 May 16 23:00 /var/log/postgresql.log.14 -rw-r----- 1 postgres logcheck 203266 May 15 23:00 /var/log/postgresql.log.15 -rw-r----- 1 postgres logcheck 201565 May 14 23:00 /var/log/postgresql.log.16 -rw-r----- 1 postgres logcheck 174947 May 13 23:00 /var/log/postgresql.log.17 -rw-r----- 1 postgres logcheck 201259 May 12 23:00 /var/log/postgresql.log.18 -rw-r----- 1 postgres logcheck 201822 May 11 23:00 /var/log/postgresql.log.19 -rw-r----- 1 postgres logcheck 201633 May 10 23:00 /var/log/postgresql.log.20 -rw-r----- 1 postgres logcheck 202129 May 9 23:00 /var/log/postgresql.log.21 -rw-r----- 1 postgres logcheck 201599 May 8 23:00 /var/log/postgresql.log.22 -rw-r----- 1 postgres logcheck 201991 May 7 23:00 /var/log/postgresql.log.23 -rw-r----- 1 postgres logcheck 175616 May 6 23:00 /var/log/postgresql.log.24 -rw-r----- 1 postgres logcheck 201433 May 5 23:00 /var/log/postgresql.log.25 -rw-r----- 1 postgres logcheck 201136 May 4 23:00 /var/log/postgresql.log.26 -rw-r----- 1 postgres logcheck 201787 May 3 23:00 /var/log/postgresql.log.27 -rw-r----- 1 postgres logcheck 200314 May 2 23:00 /var/log/postgresql.log.28 -rw-r----- 1 postgres logcheck 201067 May 1 23:00 /var/log/postgresql.log.29 [dan@dbclone:/usr/local/etc/newsyslog.conf.d]: $ | ||||
| Tags | No tags attached. | ||||
|
|
Nope, still not rotating.[dan@dbclone:/var/log]: $ ls -lt postgresql.log* -rw-r----- 1 postgres logcheck 12634528 Aug 1 09:57 postgresql.log -rw-r----- 1 postgres logcheck 202203 May 30 23:00 postgresql.log.0 -rw-r----- 1 postgres logcheck 201647 May 29 23:00 postgresql.log.1 |
|
|
That should be at 2300 UTC every day.[dan@dbclone:/usr/local/etc/newsyslog.conf.d]: $ cat postgresql # logfilename [owner:group] mode count size when flags [/pid_file] [sig_num] /var/log/postgresql.log postgres:logcheck 640 30 * $D23 N /var/db/postgres/data12/postmaster.pid 30 |
|
|
Lets's try @T00 instead of $D23 |
|
|
Ahh, it's the flag. N = indicates that there is no process which needs to be signaled when this log file is rotated. |
|
|
# logfilename [owner:group] mode count size when flags [/pid_file] [sig_num] /var/log/postgresql.log postgres:logcheck 640 30 * @T00 - /var/db/postgres/data12/postmaster.pid 30 |
|
|
Now I think it's my file name. From man newsyslog:
/usr/local/etc/newsyslog.conf.d By default each file in this directory
ending in '.conf' and not beginning with
a '.' will be included by the default
newsyslog.conf.
This host was upgraded to FreeBSD 13 recently. That's the change on newsyslog.conf My postgresql file will be renamed postgresql.conf |
|
|
Fixed:[dan@dbclone:~]: $ ls -lt /var/log/postgresql.log* -rw-r----- 1 postgres logcheck 62 Aug 4 00:00 /var/log/postgresql.log -rw-r----- 1 postgres logcheck 206449 Aug 4 00:00 /var/log/postgresql.log.0 -rw-r----- 1 postgres logcheck 12841305 Aug 3 00:00 /var/log/postgresql.log.1 -rw-r----- 1 postgres logcheck 202203 May 30 23:00 /var/log/postgresql.log.2 -rw-r----- 1 postgres logcheck 201647 May 29 23:00 /var/log/postgresql.log.3 -rw-r----- 1 postgres logcheck 205245 May 28 23:00 /var/log/postgresql.log.4 -rw-r----- 1 postgres logcheck 191818 May 27 23:00 /var/log/postgresql.log.5 -rw-r----- 1 postgres logcheck 202859 May 26 23:00 /var/log/postgresql.log.6 |
| Date Modified | Username | Field | Change |
|---|---|---|---|
| 2021-07-23 22:13 | dvl | New Issue | |
| 2021-08-01 18:40 | dvl | Note Added: 0000151 | |
| 2021-08-01 18:40 | dvl | Note Added: 0000152 | |
| 2021-08-01 18:47 | dvl | Note Added: 0000153 | |
| 2021-08-01 18:48 | dvl | Note Added: 0000154 | |
| 2021-08-01 18:51 | dvl | Note Added: 0000155 | |
| 2021-08-01 18:51 | dvl | Note Edited: 0000155 | |
| 2021-08-01 18:51 | dvl | Note Edited: 0000152 | |
| 2021-08-01 18:51 | dvl | Note Edited: 0000151 | |
| 2021-08-01 18:52 | dvl | Description Updated | |
| 2021-08-02 00:58 | dvl | Note Added: 0000159 | |
| 2021-08-04 00:01 | dvl | Note Added: 0000160 | |
| 2021-08-04 00:01 | dvl | Assigned To | => dvl |
| 2021-08-04 00:01 | dvl | Status | new => closed |
| 2021-08-04 00:01 | dvl | Resolution | open => fixed |
