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