Insufficient privilege when initiating backup

From: Cody Caughlan <toolbag(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Insufficient privilege when initiating backup
Date: 2011-11-09 19:48:58
Message-ID: CAPVp=gYoLpMZ9DWAfCuKbPmuDNeMvE1GggS2gFo8x04xZdRyyg@mail.gmail.com
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-general

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.

/Cody

Responses

Browse pgsql-general by date

  From Date Subject
Next Message John R Pierce 2011-11-09 19:57:49 Re: <IDLE> connections and cpu consumption
Previous Message Gauthier, Dave 2011-11-09 19:35:50 Re: <IDLE> connections and cpu consumption