I created a read replica of a PostgreSQL 10 instance in AWS RDS. I was assuming that my clients would be able to LISTEN for notifications on the replica, but that does not seem to be the case. I have tried to research the limitation, but I have not found anything concrete. Can clients LISTEN/UNLISTEN for NOTIFY events on a read replica?
No, that won't work:
LISTEN test;
ERROR: cannot execute LISTEN during recovery
NOTIFY test;
ERROR: cannot execute NOTIFY during recovery
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With