Re: Insufficient privilege when initiating backup

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

In response to

Browse pgsql-general by date

  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