Re: Insufficient privilege when initiating backup
От | Guillaume Lelarge |
---|---|
Тема | Re: Insufficient privilege when initiating backup |
Дата | |
Msg-id | 1320870279.2120.27.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Insufficient privilege when initiating backup (Cody Caughlan <toolbag@gmail.com>) |
Список | 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
В списке pgsql-general по дате отправления: