database role for backups?

From: kjonca(at)o2(dot)pl (Kamil =?iso-8859-2?Q?Jo=F1ca?=)
To: pgsql-admin(at)postgresql(dot)org
Subject: database role for backups?
Date: 2013-05-07 02:38:39
Message-ID: 87sj1zldjk.fsf@alfa.kjonca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin


I tried to create make backup my postrgresql cluster with amanda.
And I had to create database superuser.

I tried to create no-superuser role with only "replication" privillege,
but after run backup I got:

--8<---------------cut here---------------start------------->8---
2013-05-06 13:33:02 CEST ERROR: must be superuser to switch transaction log files
2013-05-06 13:33:02 CEST STATEMENT: SELECT file_name from pg_xlogfile_name_offset(pg_switch_xlog())
--8<---------------cut here---------------end--------------->8---

So my question is:
Can I establish postgresql role which is _not_ superuser and can execute
above statement?
KJ

PS. does news.postgresql.org work? I got 'unknown host'

--
http://blogdebart.pl/2012/06/24/hiena/
Pauca sed matura.
[Few but excellent.]
-- Gauss

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Ian Lawrence Barwick 2013-05-07 03:30:06 Re: database role for backups?
Previous Message Uwe Schroeder 2013-05-07 01:54:33 Re: top posting?