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
