Re: SIze 0 in pg_stat_file, pg_stat_progress_copy

From: Marc Millas <marc(dot)millas(at)mokadb(dot)com>
To: Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: SIze 0 in pg_stat_file, pg_stat_progress_copy
Date: 2023-04-14 16:09:44
Message-ID: CADX_1abrtFe0_B8tvH_e7CN=6CKnkLW_i3KS5urcRsLC27W6wA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Sorry...
someone did setup the log as a named pipe...

Marc MILLAS
Senior Architect
+33607850334
www.mokadb.com

On Fri, Apr 14, 2023 at 4:26 PM Marc Millas <marc(dot)millas(at)mokadb(dot)com> wrote:

> 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
> www.mokadb.com
>
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Peter J. Holzer 2023-04-14 16:31:16 Re: JSON / ASP.NET AJAX Dates support in PostgreSQL
Previous Message GF 2023-04-14 16:03:54 Re: [Extern] Re: Is a logical replication crash recovery safe?