Search Postgresql Archives

Insufficient privilege when initiating backup

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux