pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Tom Lane <tgl@sss.pgh.pa.us>
To: Zhaoxun Yan <yan.zhaoxun@gmail.com>
Cc: Ron <ronljohnsonjr@gmail.com>
Cc: pgsql-admin@lists.postgresql.org
Subject: Re: Fwd: Why does pg_rewind deny permission for pg_read_binary_file() other than 'dbname=postgres'?
Date: Thu, 12 Oct 2023 22:03:58 -0400
Message-ID: <1430191.1697162638@sss.pgh.pa.us> (raw)
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>

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





view thread (9+ messages)  latest in thread

Message-ID: <1430191.1697162638@sss.pgh.pa.us>
Permalink:  ../1430191.1697162638@sss.pgh.pa.us/
Also on:    postgresql.org/message-id/1430191.1697162638@sss.pgh.pa.us

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-admin@postgresql.org
  Cc: tgl@sss.pgh.pa.us, yan.zhaoxun@gmail.com, 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: <1430191.1697162638@sss.pgh.pa.us>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox