Hi Experts,
I'm using PostgreSQL 8.3.3 and have a question about log files that
PostgreSQL generates.
There are two ways to specify the log file path
1)pg_ctl start -l <filename>
http://www.postgresql.org/docs/8.3/interactive/app-pg-ctl.html
2)server configuration (postgresql.conf)
http://www.postgresql.org/docs/8.3/interactive/runtime-config-logging.html#RUNTIME-CONFIG-LOGGING-WHERE
I'm now considering the following settings in postgresql.conf.
log_destinatio = stderr
logging_collector = on
log_directory = 'pg_log'
log_filename = 'postgresql-%Y-%m-%d.log'
log_rotation_age = 1d
log_truncate_on_rotation = off
I just wonder whether I still should continue using 'pg_ctl start -l
<filename>' to keep useful information about PostgreSQL server status.
I tried enabling both of two log files but few messages were written
to the former one.
It seems only messages generated before those parameters are
recognized and ones generated by pg_ctl itself are written.
For instance, I can see some messages by issueing 'pg_ctl start' while
PostgreSQL is already up.
If all messages while PostgreSQL server is running are wrintten to the
file specified by log_directory and log_filename, I'd like to consider
to start up PostgreSQL as follows:
$pg_ctl start > /dev/null
Any comments or suggestions would be greatly appreciated.
Thanks in advance,
ebi