From: | Mateusz Henicz <mateuszhenicz(at)gmail(dot)com> |
---|---|
To: | Wiwwo Staff <wiwwo(at)wiwwo(dot)com> |
Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
Subject: | Re: pg_rewind and replication user |
Date: | 2023-02-01 14:37:19 |
Message-ID: | CAN6i3YNY5Tgm0q--W_-wTfTj8N6PSwJ2PgTZ-_Qc-N4dZXoGxA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Hey,
If you would look into docs
https://www.postgresql.org/docs/current/app-pgrewind.html on the "Notes"
section you will find a list of permissions that user needs to have to be
able to run pg_rewind.
Cheers,
Mateusz
śr., 1 lut 2023, 15:09 użytkownik Wiwwo Staff <wiwwo(at)wiwwo(dot)com> napisał:
> Hi!
> Provided my replication user created with
> CREATE USER repl_user REPLICATION LOGIN ENCRYPTED PASSWORD'....';
>
> If I run pg_rewing referring to this user
> postgres(at)host1:~: pg_rewind -D $PGDATA --source-server="host=nre_primary
> port=5432 user=repl_user passfile='/var/lib/postgresql/.pgpass'
> dbname=postgres" -P -R
>
> I get
> pg_rewind: connected to server
> pg_rewind: error: could not fetch remote file "global/pg_control": ERROR:
> permission denied for function pg_read_binary_file
>
> My question/doubt is: i can need to run pg_rewind referring to a superuser
> only? Or i am "just" forgetting some grant to the replication user?
>
> Thanks!
>
>
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2023-02-01 15:05:44 | Re: 38.10.6. Composite-Type Arguments C-language function code demo works for int, but not for numeric. |
Previous Message | Wiwwo Staff | 2023-02-01 14:09:20 | pg_rewind and replication user |