I am attempting to run select pg_start_backup('backup-2011-11-09');
But it is just hanging, I've given it 3 minutes. When I view pg_stat_activity I see "<insufficient privilege>" in the current_query column. I've quadruple checked that the user (postgres) has the Replication role: batch_api_production=> \du+ List of roles Role name | Attributes | Member of | Description ------------+------------------------------------------------+-----------+------------- batch | Create DB | {} | postgres | Superuser, Create role, Create DB, Replication | {} | replicator | Replication +| {} | | 2 connections | | Any help would be appreciated. /Cody