PostgreSQL - Limit user to connect only to replica (and not to the master node)

Viewed 503

Is it possible to limit a user (in this case a read only one) to be able to connect just to a read replica instance and not the main one?

(i know a firewall is an option, i am just wondering if there is something with PostgreSQL i can do instead)

1 Answers
Related