Windows10-在PostgreSQL 10上查看当前日志

Question

https://groups.google.com/forum/#!topic/comp.lang.python/j4QvrC_FuOI

以下语句来自上面的链接(使用Psycopg2)：

>> pool=ThreadedConnectionPool(0,5,<connection_args>) 
>> conn1=pool.getconn() 
>> conn2=pool.getconn() 
>> pool.putconn(conn1) 
>> pool.putconn(conn2) 
>> conn3=pool.getconn() 
>> pool.putconn(conn3) 

2017-06-02 14:30:26 AKDT LOG:  connection received: host=::1 port=64786 
2017-06-02 14:30:26 AKDT LOG:  connection authorized: user=logger database=flightlogs 
2017-06-02 14:30:35 AKDT LOG:  connection received: host=::1 port=64788 
2017-06-02 14:30:35 AKDT LOG:  connection authorized: user=logger database=flightlogs 
2017-06-02 14:30:46 AKDT LOG:  disconnection: session time: 0:00:19.293 user=logger database=flightlogs host=::1 port=64786 
2017-06-02 14:30:53 AKDT LOG:  disconnection: session time: 0:00:17.822 user=logger database=flightlogs host=::1 port=64788 
2017-06-02 14:31:15 AKDT LOG:  connection received: host=::1 port=64790 
2017-06-02 14:31:15 AKDT LOG:  connection authorized: user=logger database=flightlogs 
2017-06-02 14:31:20 AKDT LOG:  disconnection: session time: 0:00:05.078 user=logger database=flightlogs host=::1 port=64790 

我可以在哪里查看这些日志？我访问了C:\Program Files\PostgreSQL\10\data\log并查看了日志文本文件，但它似乎没有最新的日志记录。如何在运行SQL语句时实时查看日志更新？

Answer 1

我的日志在..data\pg_log文件夹中，如果您的日志中没有显示所需的sql，则可能需要在postgresql.conf文件中启用日志记录。

#log_min_duration_statement = -1    # -1 is disabled, 0 logs all statements
log_min_duration_statement = 0

如果更改日志记录，则需要重新启动Postgresql