Re: 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