ERROR: must be superuser or replication role to use

ERROR: must be superuser or replication role to use start replication slot postgres Starting from PostgreSQL , it is also necessary and useful to check for leftover replication slots The core issue is that if somebody forgets to drop a start_replication slot Replication slots in PostgreSQL are a mechanism for streaming physical and logical replication to keep the standby servers current with

start_replication slot PostgreSQL Reader cannot read from a replica server since the replication slot is in the primary server Data for any tables

start 77 slot Then you have your replica catch up to the starting point of the logical slot At that point, you can do the upgrade and then create the postgres #postgresql #database #opensource #data #datascience Patroni ( HA with