Re: pg_rewind and replication user

2023-02-01 Thread Mateusz Henicz
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 napisał: > Hi! > Provided my r

pg_rewind and replication user

2023-02-01 Thread Wiwwo Staff
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@host1:~: pg_rewind -D $PGDATA --source-server="host=nre_primary port=5432 user=repl_user passfile='/var/lib/postgresql/.pgpass' dbname=