Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UZYDY-0006Vo-VV for pgsql-admin@arkaria.postgresql.org; Tue, 07 May 2013 03:05:29 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UZYDY-0006ax-Et for pgsql-admin@arkaria.postgresql.org; Tue, 07 May 2013 03:05:28 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UZYDW-0006ap-HN for pgsql-admin@postgresql.org; Tue, 07 May 2013 03:05:26 +0000 Received: from moh2-ve2.go2.pl ([193.17.41.200]) by magus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UZYDS-00015K-QD for pgsql-admin@postgresql.org; Tue, 07 May 2013 03:05:26 +0000 Received: from moh2-ve2.go2.pl (unknown [10.0.0.200]) by moh2-ve2.go2.pl (Postfix) with ESMTP id 2A189B00053 for ; Tue, 7 May 2013 05:05:20 +0200 (CEST) Received: from unknown (unknown [10.0.0.42]) by moh2-ve2.go2.pl (Postfix) with SMTP for ; Tue, 7 May 2013 05:05:19 +0200 (CEST) Received: from circinus.aster.net.pl [85.222.105.11] by poczta.o2.pl with ESMTP id YEdbEA; Tue, 07 May 2013 05:05:19 +0200 Received: from kjonca by alfa.kjonca with local (Exim 4.80) (envelope-from ) id 1UZXnc-0000dk-H4 for pgsql-admin@postgresql.org; Tue, 07 May 2013 04:38:40 +0200 From: kjonca@o2.pl (Kamil =?iso-8859-2?Q?Jo=F1ca?=) To: pgsql-admin@postgresql.org Subject: database role for backups? Date: Tue, 07 May 2013 04:38:39 +0200 Message-ID: <87sj1zldjk.fsf@alfa.kjonca> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/24.2 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain X-O2-Trust: 2, 65 X-O2-SPF: neutral X-Pg-Spam-Score: -1.9 (-) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-admin Precedence: bulk Sender: pgsql-admin-owner@postgresql.org 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 -- Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin