Skip to content

{ Tag Archives } Postgres

Postgresql 8.4.3 upgrade troubles

I recently upgraded several of postgres DB server to the latest version 8.4.3.  The process was pretty simple for the 8.3.x clusters. Make a copy of the postgres configuration files. cp /var/lib/pgsql/data/*.conf /tmp/. pg_dump each DB instance in plaintext format: pg_dump -d dbname -Fp -o ./dbname.dmp.sql Stop postgres: pg_ctl stop Configure the new pgdg yum [...]

Also tagged

Database Schema Migration Tool

I have been working on database schema migration tools lately. We have 25+ database instances spread across 7 servers and sometimes it can get difficult to track which SQL changes got run against each of the databases (especially in the development environments). First I surveyed some of the existing tools.  I looked at Rails Migrations, [...]

Also tagged

SQL Hacks

Most of my SQL is usually something along the lines of: CREATE TABLE …. DROP DATABASE …. But recently I have been working on a report that has been causing some trouble. The report issues a large SQL query for each of our partners and then a fancy perl script filters, sorts, aggregates, and formats [...]

Also tagged , , ,

Londiste process dead this morning

I came in this morning and found that the londiste replay job that replicates into our disaster recovery database had silently failed. The process was still running. Replication lag was over 11 hours at that point so that implies that something strange occurred at 10 pm last night. The postgres logs for the DR database [...]

Also tagged ,

Londiste Memory Usage

During our last major software release we made a pretty massive schema update to the primary postgres database. We pulled several columns out of one of our core tables and moved them into a separate table. We added triggers, dropped tables, added columns, etc. After all the dust had settled one of the lead developers [...]

Also tagged ,

Percona Performance Conference

I attended the Percona Performance Conference today.  It was an interesting event since it was like a mini-conference within the MySQL 2009 conference which I had not registered for (so I felt a bit like a gate-crasher).  Anyway, the price was right (free!) and the content was good so I thought I would share some [...]

Also tagged , , , , ,