Hi community, When I use the postgres, I check the log.(I use the -l open the log) As you can see, I type code like this:
postgres=# show logging_collector; logging_collector ------------------- off (1 row) postgres=# ^C Follow the document, when logging_collector is off, there's no log output, but when I check my 'postgres' directory: [postgres@fedora postgres]$ ls build.sh logfile src startdb.sh stopdb.sh update.sh [postgres@fedora postgres]$ cat logfile 2023-07-24 09:54:59.668 CST [35872] LOG: starting PostgreSQL 17devel on x86_64-pc-linux-gnu, compiled by gcc (GCC) 13.1.1 20230614 (Red Hat 13.1.1-4), 64-bit 2023-07-24 09:54:59.668 CST [35872] LOG: listening on IPv6 address "::1", port 5432 2023-07-24 09:54:59.668 CST [35872] LOG: listening on IPv4 address "127.0.0.1", port 5432 2023-07-24 09:54:59.684 CST [35872] LOG: listening on Unix socket "/tmp/.s.PGSQL.5432" ... In a word, the log is actually open. (My startup command: pg_ctl -l logfile /home/postgres/postgres/bin/bin/pg_ctl -l logfile -D /home/postgres/postgres/data start) So It's confuse me, the confilt of logging_collector & logfile. Can someone give me some advice? Thanks in advance! Yours, Wen Yi