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
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"
...
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