I am using streaming replication to replicate my postgres database to a slave.
I want to grant read-only access to the slave database without granting read-only access to the master.
is this possible?
will creating a new user on the slave break the replication?
what is the best way of doing this?