Daily Archives: September 4, 2009

Tomcat Performance Turning

Enable gzip compression for generated text content HTML and XML content usually compresses extremely well using gzip. Most web and application servers support gzip compression. For example, Tomcat 5 supports the attribute gzip on the element. compression=”on” compressionMinSize=”300″ noCompressionUserAgents=”gozilla, traviata” … Continue reading

Posted in App Servers | Tagged , , | Leave a comment

Postgresql – Logging SQL query and time for Analysis

Change the following log option in postgresql.conf as log_error_verbosity = default # terse, default, or verbose messages log_duration = on log_line_prefix = ‘%t%d’ # Special values: log_statement = ‘all’ # none, mod, ddl, all

Posted in Database, Linux | Tagged , , | Leave a comment

Postgresql Installation through RDP

Postgresql will refuse to install through an RDP section and it will fail with a message below. Failed to run initdb: !128 Please see the logfile in ‘C:program FilesPostgreSQL8.2beta1tmpinitdb.log’. Note! You must read/copy this logfile before yuo click OK, or … Continue reading

Posted in Database | Tagged , , , | Leave a comment

Postgresql – backing up database

Database can be backed up with the pg_dump command. Some times restoring the backed up database will fail due to version conflict. To resolve that use the command # pg_dump -d -O -Fp -i -x -f dump-filename.sql db-name Backup  a … Continue reading

Posted in Database, Linux | Tagged , , | Leave a comment

VNC server with resumable sessions and GDM login

Make these changes while logged into gnome: Go to System -> Administration -> Login Window (General tab) and uncheck “Disable multiple logins for a single user.” Now go to the Remote tab. Change Style: to “Same as Local” Still on … Continue reading

Posted in Linux | Tagged , , , | 3 Comments