N
N
Nikolai Savelyev2020-11-23 08:54:54
linux
Nikolai Savelyev, 2020-11-23 08:54:54

Postgresql can work without pg_log, pg_clog and pg_xlog?

Good afternoon.
Installed postgresql 11 a year ago, everything works.
There were performance problems, I started digging and found in the logs:

]ERROR:  could not open directory "pg_xlog": No such file or directory
]ERROR:  function pg_current_xlog_location() does not exist at character 30


Looked - really, there is no pg_log, pg_clog and pg_xlog. In the meantime, everything seems to be working.
The last thing I did was fstrim -v / (computer on am4 socket 570 chipset, a year ago there was a 5.2 kernel, there was a bug with trim for nvme, I installed the 5.8 kernel on the weekend, the trim worked).

So what's with the lack of pg_log, pg_clog and pg_xlog?

Answer the question

In order to leave comments, you need to log in

1 answer(s)
M
Melkij, 2020-11-23
@nikweter

postgresql 11

pg_xlog is not database specific. Was critical until pg10, then renamed to pg_wal. Similarly, the pg_current_xlog_location function.
Probably your monitoring is not capable of pg10+.
pg_clog was then renamed to pg_xact in pg10. Just as critical. Both renamings are intended to interfere with thinking. that these are "some unnecessary logs, I'll delete"
pg_log does not apply to the database.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question