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