nixCraft
Linux / UNIX Tech Support Forum
Postgresql logging
This is a discussion on Postgresql logging within the Databases servers forums, part of the Mastering Servers category; I am able to log all statements in postgreSQL, but also want to log page(php) name, the ddl/dml request is ...
|
|||||||
| Databases servers Discussions of databases of all types - especially MySQL. |
 |
|
|
LinkBack | Thread Tools | Display Modes |
06-11-2009, 06:35 PM
|
||||
|
||||
Postgresql logging
I am able to log all statements in postgreSQL, but also want to log page(php) name, the ddl/dml request is coming to postgreSQL.
Is there any way to accomplish that ? 
|
| Sponsored Links | ||
|
|
|
06-12-2009, 03:13 PM
|
||||
|
||||
|
You will get that data from webserver logs and not from pgsql logs as pgsql has no idea about php pages.
__________________
Vivek Gite Linux Evangelist  Be proud RHEL user, and let the world know about your enterprise choices! Join RedHat user group. Always use CODE tags for posting system output and commands! Do you run a Linux? Let's face it, you need help
|
| The Following User Says Thank You to nixcraft For This Useful Post: | ||
kasimani (06-18-2009)
| ||
|
06-14-2009, 07:20 AM
|
||||
|
||||
|
The ddl/dml logging has to be enabled from the postgresql.conf files which is located in the data directory of postgresql. For the php file name, as Vivek has correctly suggested, you will have to look into your web server logs.
Last edited by amitabh; 06-14-2009 at 10:34 AM.
|
| The Following User Says Thank You to amitabh For This Useful Post: | ||
kasimani (06-18-2009)
| ||
|
| Tags |
| linux , pgsql , php , postgresql |
Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) |
|
| Thread Tools | |
| Display Modes | |
Linear Mode
|
|
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| timer for logging out from PuTTy | eawedat | Shell scripting | 4 | 08-16-2008 04:15 AM |
| Call Logging and Asset Mgmnt SW | ricc | Linux software | 1 | 06-29-2007 01:45 AM |
| Howto list or display databases on a PostgreSQL PgSQL server | sweta | Databases servers | 1 | 03-06-2007 12:17 PM |
| Logging File Accesses | madz | Shell scripting | 2 | 11-08-2006 01:54 AM |
| MRTG stops logging | nathan86 | Linux software | 12 | 03-23-2005 07:14 PM |
All times are GMT +5.5. The time now is 09:19 AM.
