"ERROR: permission denied for table node" using failover command about pg_auto_failover HOT 4 CLOSED

Hi @Wolfsrudel, because we use Synchronous Replication, the failover is done in a way that prevents data loss. As a result it can be considered a switchover for maintenance, and that's why we don't have another API for that use case.

from pg_auto_failover.

Hi @Wolfsrudel, thanks for the feedback.

The user autoctl_node has just enough privileges to be used from a node running the pg_autoctl tool. This does not include triggering a manual failover.

To use the perform_failover API you need to log-in to the monitor as the database owner role: autoctl. The creation steps of the database cluster for the monitor do not include opening the HBA for this role though, so the security of who's allowed to trigger a manual failover is for you to solve.

We should certainly extend our documentation of those API entries: leaving the issue open so that we have a chance to fix this.

from pg_auto_failover.

I'm fine with this. :)

from pg_auto_failover.

@DimCitus: is it possible to do a manual switchover for maintenance tasks? Failover is the hard way, I guess.

from pg_auto_failover.