SIze 0 in pg_stat_file, pg_stat_progress_copy - Mailing list pgsql-general

From Marc Millas
Subject SIze 0 in pg_stat_file, pg_stat_progress_copy
Date
Msg-id CADX_1abK4jqmP0xCEmZXKLbZf+WKgXukOosdM3SBchRx4kFuvg@mail.gmail.com
Whole thread Raw
Responses Re: SIze 0 in pg_stat_file, pg_stat_progress_copy
List pgsql-general
Hi,

on a debian machine, with a postgres 14,2 server

logs in a dedicated  directory (not log)
when logged as superuser, I get:
--pg_stat_file for the current logfile says size 0,
--pg_ls_logdir answers 0 files,
--pg_ls_dir, for the log directory provides postgres.csv, postgres.json,... list of files
--and when running a copy from the current logfile with a where clause to choose only the current day logs, the bytes total column is 0

what can provides such a behaviour ?

thanks,


Marc MILLAS
Senior Architect
+33607850334

pgsql-general by date:

Previous
From: 黄宁
Date:
Subject: cursor with hold must be save to disk?
Next
From: Adrian Klaver
Date:
Subject: Re: cursor with hold must be save to disk?