News for hackers. Stuff that matters.
Re:Postgression - A PostgreSQL database for every test case by olefoo on Monday January 21, 2013 @08:36PM (#5094978)
This may be a small nit, especially since this is specifically a public test facility. But you might want to restrict the guest roles to only access their own database public schema.

I can't see other's query activity, but I can see some of the pg_catalog tables.

For instance

    select count(*) from pg_stat_database;
     count 
   -------
     1900
   (1 row)
Re:Postgression - A PostgreSQL database for every test case by zaidos on Monday January 21, 2013 @08:52PM (#5095035)
By default, Heroku allows roles on their shared database plans to view limited info about databases on the same machine. Stuff like name, type and owner are visible.

Here is a sample response when attempting to do anything with a database other than your own:

FATAL: permission denied for database "xxxxxxxxxxxx" DETAIL: User does not have CONNECT privilege. Previous connection kept