#

require pgdbcmd

pgdb_getpids_bydb ()
{
        local dbname=$1
        local -a pids

        pids=($(
                PGDATABASE=postgres \
                PGUSER=postgres \
                pgdbcmd "
                        SELECT  procpid
                        FROM    pg_stat_activity
                        WHERE   datname  = '$dbname'
                        AND     usename != 'postgres'
                ;"
        ))

        echo -n ${pids[@]}
}
# vim:syn=sh:ft=sh