Category Archives: Postgres

Ubuntu 10.04 (Lucid) issues with Postgres and boot

Posted on June 3, 2011 by iiilx

So annoying! I had boot errors like mount /dev/shm terminated with status 32 . I temporarily fixed it by creating the directory /dev/shm (mkdir /dev/shm) and rebooting, then logging into my normal ubuntu and editing /etc/fstab to remove a line … Continue reading →

Posted in Linux, Postgres | Leave a comment

More on analyzing Postgres queries

Posted on June 1, 2011 by iiilx

On a home page for my django site, I have the following queries being run: SELECT “auth_group”.”id”, “auth_group”.”name” FROM “auth_group” INNER JOIN “auth_user_groups” ON (“auth_group”.”id” = “auth_user_groups”.”group_id”) WHERE “auth_user_groups”.”user_id” = 12 and SELECT “auth_group”.”id”, “auth_group”.”name” FROM “auth_group” WHERE “auth_group”.”name” = … Continue reading →

Posted in Postgres, Programming | Leave a comment

Postgres 8.4 on Ubuntu 10.04 Lucid not working

Posted on June 1, 2011 by iiilx

This has been a pain in the ass. After upgrading my system from Karmic to Lucid, postgres stopped working. Postgres server wouldn’t start. First I got a locale error, so I installed a UTF-8 US locale. Then Postgres wouldn’t start … Continue reading →

Posted in Linux, Postgres | Leave a comment

How to log all Postgres queries and view query statistics using pgFouine

Posted on May 25, 2011 by iiilx

The point of this is to get some nice statistics on the queries being run on your postgres db. For example, look at this sample report generated by pgFouine. If you want this, continue the tutorial. First off, this tutorial … Continue reading →

Posted in Postgres | 2 Comments