Killing sessions for database in postgres

SELECT pg_terminate_backend(pid) FROM pg_stat_activity WHERE pid  pg_backend_pid() AND datname = 'dbname';

For old versions of postgres:

SELECT pg_terminate_backend(procpid) FROM pg_stat_activity 
WHERE procpid  pg_backend_pid() AND datname = 'database_name';

More: http://stackoverflow.com/questions/5108876/kill-a-postgresql-session-connection


Flash problems in ubuntu 12.04

To make flash plugin run well on ubuntu:

  • choose flashplugin-installer version of flash in chrome
  • invoke
    sudo add-apt-repository ppa:ubuntu-audio-dev/ppa; sudo apt-get update;sudo apt-get dist-upgrade; sudo apt-get install linux-sound-base alsa-base alsa-utils linux-image-`uname -r` libasound2; sudo apt-get -y --reinstall install linux-sound-base alsa-base alsa-utils linux-image-`uname -r` libasound2; killall pulseaudio; rm -r ~/.pulse*; sudo usermod -aG `cat /etc/group | grep -e '^pulse:' -e '^audio:' -e '^pulse-access:' -e '^pulse-rt:' -e '^video:' | awk -F: '{print $1}' | tr '\n' ',' | sed 's:,$::g'` `whoami`

The second one is the first step of: https://help.ubuntu.com/community/SoundTroubleshootingProcedure