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 | Resend email |
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
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 |