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

Reply via email to