how to monitor pg log? postgresql log iteam failed.

[lishengxian]

HI all

zabbix agent don't have permission to access the pg log. because the $PGDATA need the 700 permission. anyone face the same issue?

[knih]

You can use a different directory.

# mv ${PGDATA}/pg_log /var/log/postgres
# chmod 0755 /var/log/postgres
# ln -s /var/log/postgres ${PGDATA}/pg_log
# chown -h postgres.postgres ${PGDATA}/pg_log

{$PGLOGDIR} => /var/log/postgres

And then, give the zabbix user read permission such as:

log_file_mode = 0644

[lishengxian]

Thank you @knih

[blogh]

This is not supported by PostgreSQL. The only symlink allowed in $PGDATA is pg_xlog (now called pg_wal).

You should use the GUC: log_directory (if you use the logging collector).
https://www.postgresql.org/docs/9.5/static/runtime-config-logging.html#GUC-LOG-DIRECTORY

btw: thx for the software :)

EDIT: Not supported is probably a bit strong (I cannot find where I read this)... Still looking for it :)
EDIT2: user symlinks (not pg_tblspc)