logging_collector is off, but the logging is opening

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;
&nbsp;logging_collector
-------------------
&nbsp;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&nbsp; logfile&nbsp; src&nbsp; startdb.sh&nbsp; stopdb.sh&nbsp; update.sh

[postgres(at)fedora postgres]$ cat logfile
2023-07-24 09:54:59.668 CST [35872] LOG:&nbsp; 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:&nbsp; listening on IPv6 address "::1", port 5432
2023-07-24 09:54:59.668 CST [35872] LOG:&nbsp; listening on IPv4 address "127.0.0.1", port 5432
2023-07-24 09:54:59.684 CST [35872] LOG:&nbsp; 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 &amp; logfile.

Can someone give me some advice?
Thanks in advance!

Yours,
Wen Yi

Responses

Browse pgsql-general by date

  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