|
Home > Archive > PostgreSQL Discussion > May 2005 > More detailed error logging?
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
More detailed error logging?
|
|
|
| Is it possible to have the database name, datetime,
and maybe even the query itself show up in pgsql's
error log?
Thanks,
CSN
____________________
______________
Do you Yahoo!?
Yahoo! Small Business - Try our new Resources site
http://smallbusiness.yahoo.com/resources/
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
| |
| Richard Huxton 2005-05-25, 7:23 am |
| CSN wrote:
> Is it possible to have the database name, datetime,
> and maybe even the query itself show up in pgsql's
> error log?
Plenty of options to log all sorts of info. See the manuals chapter
"16.4.6. Error Reporting and Logging" for details.
You can even increase detail settings in one particular connection using
SET ...
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere
" to majordomo@postgresql
.org)
| |
|
|
|
|
|