In order to troubleshoot a suspected issue, how can the logs of the LUA PostgreSQL service be viewed? Information about events seems to be missing.
Symptoms
After installing LiveUpdate Administrator 2.x (LUA 2.x) on a server, the Windows Application Event Log will contain entries similar to:
This is normal behavior. PostgreSQL is an open source object-relational database management system (RDBMS) that has been engineered to operate on many different platforms and operating systems. It has not been designed to record its logs to the Windows Event Logs.
By default, logging is disabled. Logging can be enabled to help troubleshoot an issue, though there will be an impact on the server's resources. To enable and configure the level of database logging, alter the postgresql.conf file. The default location in LUA 2.x is in C:\Program Files\Symantec\LiveUpdate Administrator\pgsql\data.
Open this file in a text editor and scroll down to the ERROR REPORTING AND LOGGING section.
Uncomment (remove the # sign) from the following lines:
Choose the logging level by selecting the desired value.
Important Note: The following examples show the maximum debug levels. A server should not be left running indefinitely with debug logging enabled. Do not configure debug5 logging when LUA 2.x is performing a purge operation. Always disable or decrease the logging level after troubleshooting is complete.
After changes are made to postgresql.conf, the LUA PostgreSQL service must be restarted. Detailed steps on how to stop and start LUA 2.x services via the command line can be found in the Technical Information section, below.
Log files will be found in C:\Program Files\Symantec\LiveUpdate Administrator\pgsql\data\pg_log and have names similar to postgresql-2009-04-21_095211.log.
Technical Information
1) Open a command prompt to stop the "LUA Apache Tomcat" service. (Be sure to use the " " marks as the service name contains a space.)
Command:
net stop "LUA Apache Tomcat"
Output:
The LUA Apache Tomcat service is stopping.
The LUA Apache Tomcat service was stopped successfully.
2) Stop the "LUA PostgreSQL" service.
Command:
net stop "LUA PostgreSQL"
Output:
The LUA PostgreSQL service is stopping.
The LUA PostgreSQL service was stopped successfully.
3) Now restart the "LUA PostgreSQL" service to load the new configuration file.
Command:
net start "LUA PostgreSQL"
Output:
The LUA PostgreSQL service is starting.
The LUA PostgreSQL service was started successfully.
4) Then start the "LUA Apache Tomcat" service.
Command:
net start "LUA Apache Tomcat"
Output:
The LUA Apache Tomcat service is starting.
The LUA Apache Tomcat service was started successfully.