From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zhaoxun Yan <yan.zhaoxun@gmail.com>
cc: Ron <ronljohnsonjr@gmail.com>, pgsql-admin@lists.postgresql.org
Subject: Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file()
 other than 'dbname=postgres'?
In-reply-to: 
 <CADEX6_WRFPMCbHaC4nj1N6dTJTBtyz8p-b75idyg4kZKaE+A7g@mail.gmail.com>
References: 
 <CADEX6_U5V8CoNY7ftjy-fcrEYR0beG2_6PBSEDtEVb3zYt-_sg@mail.gmail.com>
 <CADEX6_U=8O1OoYzAOvBuq1Mc1+pm_6ZB+Oo+_g6yr-vZ_7n=uA@mail.gmail.com>
 <ef7585c0-8a04-a9d3-8724-de2c2abac3c7@gmail.com>
 <CADEX6_WJO0+VCHsgt736x5Y+a9XTrQyF0MHV1JkL51A28RM-GQ@mail.gmail.com>
 <90bfa111-85f5-a5db-4026-dc1587ab5a11@gmail.com>
 <CADEX6_WRFPMCbHaC4nj1N6dTJTBtyz8p-b75idyg4kZKaE+A7g@mail.gmail.com>
Comments: In-reply-to Zhaoxun Yan <yan.zhaoxun@gmail.com>
	message dated "Fri, 13 Oct 2023 09:41:48 +0800"
MIME-Version: 1.0
Content-Type: text/plain; charset="us-ascii"
Content-ID: <1430190.1697162638.1@sss.pgh.pa.us>
Date: Thu, 12 Oct 2023 22:03:58 -0400
Message-ID: <1430191.1697162638@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/1430191.1697162638%40sss.pgh.pa.us>
Precedence: bulk

Zhaoxun Yan <yan.zhaoxun@gmail.com> writes:
> The results are the same, 'dbname=repmgr' is the root cause of the error,
> since 'dbname=postgres' went well with both 'user=rep' and 'user=rewinder',
> while 'dbname=repmgr' generates exactly the same error.

As far as I can tell, you granted permissions on that function
in the postgres database, but not any other database.  Function
permissions, like most others, are database-local in Postgres.

			regards, tom lane