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