pg_logdir_ls function throwing an error if log_filename name is not default

From: tushar <tushar(dot)ahuja(at)enterprisedb(dot)com>
To: PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org>
Subject: pg_logdir_ls function throwing an error if log_filename name is not default
Date: 2018-10-24 14:56:28
Message-ID: 0f1624a2-e515-1f23-d7b7-b38a1a96b61a@enterprisedb.com
Views: Raw Message | Whole Thread | Download mbox
Thread:
Lists: pgsql-hackers

Hi ,

Please refer this small testcase -

Open postgresql.conf file and set -

log_destination = 'stderr'
logging_collector = on
log_directory = 'pg_log1'
log_filename = 'abcd-%Y-%m-%d_%H%M%S.log'

restart the server  , connect   to psql terminal and create adminpack
extension and fire pg_logdir_ls function

postgres=# create extension adminpack;
CREATE EXTENSION
postgres=# SELECT filename, filetime FROM pg_logdir_ls() AS A(filetime
timestamp, filename text) ORDER BY filetime ASC;
ERROR:  the log_filename parameter must equal
'postgresql-%Y-%m-%d_%H%M%S.log'
postgres=#

postgres=# show log_filename ;
      log_filename
-------------------------
 abcd-%Y-%m-%d_%H%M%S.log
(1 row)

postgres=#

Is this an expected , if so - any work around ?

--
regards,tushar
EnterpriseDB https://www.enterprisedb.com/
The Enterprise PostgreSQL Company

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Fabien COELHO 2018-10-24 15:08:00 Re: pgbench - add pseudo-random permutation function
Previous Message Hironobu SUZUKI 2018-10-24 14:55:57 Re: pgbench - add pseudo-random permutation function