From: | Wen Yi <wen-yi(at)qq(dot)com> |
---|---|
To: | pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | logging_collector is off, but the logging is opening |
Date: | 2023-07-25 21:43:50 |
Message-ID: | tencent_D55E5DE56A94292F645E5CBB1B8A348CCB06@qq.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)fedora postgres]$ ls
build.sh logfile src startdb.sh stopdb.sh update.sh
[postgres(at)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
From | Date | Subject | |
---|---|---|---|
Next Message | Amn Ojee Uw | 2023-07-25 22:10:24 | Re: Nu-B here |
Previous Message | Stephen Frost | 2023-07-25 13:49:05 | Re: Error 503 Backend fetch failed |