|
|
PostgreSQL OpenSource Database
|
5.3 Debugging PostgreSQL
| ← 5.2 Basic Authorization | [ up ] - [ TOC ] - [ A - Z ] | 5.4 Backup & Restore → |
(Construction)
You can configure a separate log file postgres.log / postgres.err with PostgreSQL at startup.
e.g.
su - postgres -c "/usr/local/pgsql/bin/postmaster -i -p 5432 >/var/log/postgres.log 2>/var/log/postgres.err &"
Or like this:
su - postgres -c "$POSTGRES -D $PGDATA -l /var/log/postgres start"
There must be some configuration key(s) you could increase the debug level e.g. in postgresql.conf (?).
If you had a better advice, please let me know.
Might be helpful:
>I've run postmaster with the highest >> possible debug level but the SQL statements are not being logged yet You need to turn on log_statement ... regards, tom lane
Further Debugging Links
-
PostgreSQL.org/docs/7/static/trouble18048.htm
- Reference
Debugging Messages. PostgreSQL Troubleshooting
postgresql.org/docs/7/static/trouble18048.htm