Insufficient privilege when initiating backup

On Wed, 2011-11-09 at 11:48 -0800, Cody Caughlan wrote:

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.

You should give it the other argument, which is a boolean to force a
checkpoint. So, try this:

select pg_start_backup('backup-2011-11-09', true);

Should be faster :)

--
Guillaume
http://blog.guillaume.lelarge.info
http://www.dalibo.com