Database moved

2008-05-22 07:04:00 | johann | #

Today I have moved the PostgreSQL database to the new server as well. There was a half hour of downtime around 9pm PDT (4am UTC) for the database dump and import. The old database server was heavily overloaded, leading to slow response time and many screenshot errors over the last week. The move makes the following improvements:

• Fixed the error message 503 Server overloaded.
• Fixed the error message FATAL: connection limit exceeded for non-superusers.
• Server poll latency reduced from 10+ seconds to 0.4 seconds.
• Similar speedup for browser redirect (fixed error code 672).
• Database replication with Slony-I no longer necessary.
• Page load times on the web interface reduced from 3+ seconds to less than one.
• Database connection for API server is now local.
• Software upgraded from PostgreSQL 8.2.7 to 8.3.1.
• Database schema reloaded from current ShotServer trunk.

The scripts that I wrote for the database import are available here:

• browser:/trunk/scripts/extract_tables.py
• browser:/trunk/shotserver/sql