| From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
|---|---|
| To: | Cody Caughlan <toolbag(at)gmail(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Insufficient privilege when initiating backup |
| Date: | 2011-11-09 20:24:39 |
| Message-ID: | 1320870279.2120.27.camel@localhost.localdomain |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Gauthier, Dave | 2011-11-09 21:18:20 | Re: <IDLE> connections and cpu consumption |
| Previous Message | John R Pierce | 2011-11-09 19:57:49 | Re: <IDLE> connections and cpu consumption |