Skip site navigation (1) Skip section navigation (2)

Peripheral Links

Header And Logo

PostgreSQL
| The world's most advanced open source database.

Site Navigation

Search for
  Advanced Search

Admin pack's "logfile" doesn't work



Hi,

I have PgAdmin 1.6.2 talking to a PostgreSQL 8.2.3 server with the distributed admin pack installed (from source's contrib/adminpack), and have ran the adminpack.sql script against the postgres database.  If, in PgAdmin, I click Tools > Server Status and select the "logfile" tab, I get the following error:

"redirect_stderr not enabled or log_filename misconfigured."

My PostgreSQL server is configured as follows:

silent_mode --- on
log_destination --- stderr
log_directory --- /var/log/pgsql
log_filename --- postgresql.%Y%m%d.log
log_rotation_age --- 1d
redirect_stderr --- on

I've tried it with silent_mode set to "off" and stopped/started PostgreSQL, but it still doesn't work.

Is there anything else I need to check/change to get PgAdmin reading the log file?  Obviously the log is readable/writeable to the postgresql user account, and is around 400KB per day.

Thanks,

Andy.


Home | Main Index | Thread Index

Privacy Policy | PostgreSQL Archives hosted by Command Prompt, Inc. | Designed by tinysofa
Copyright © 1996 – 2008 PostgreSQL Global Development Group