LISTEN/NOTIFY on AWS Aurora/postgres
I am hoping to implement a trigger that fires a notify on table change in PostgreSQL, but I am unable to find any definite answer to if it would work in a cluster.
Does PostgreSQL listen/notify work on AWS Aurora (both provisioned and serverless), and can I expect all clients to receive notifications regardless of what instance they are connected to?
If yes, are there any major performance concerns?
Thanks :)
The best AWS Documentation implies - YES, it does work
Specifically for Aurora Serverless, there is an advisory that "LISTEN/NOTIFY" is NOT RECOMMENDED. This implies that it's possible with Aurora Serverless but not advisable. It also implies that normal RDS LISTEN/NOTIFY does work and is ok to use.
https://docs.aws.amazon.com/AmazonRDS/latest/AuroraUserGuide/aurora-serverless.html
Currently, certain SQL queries and commands, such as cursors with hold (DECLARE name ... CURSOR WITH HOLD FOR query); session-level advisory locks; temporary relations; and asynchronous notifications (LISTEN, NOTIFY commands) prevent scaling and are not recommended
My own quick test on AWS shows - Yes, it does work
- Launch Instance with Public Access
...
- Allow Traffic
- Run command in dbeaver
Note: This test doesn't show a successful receipt of a notification. That will need a quick console application to test that.
- How can I select rows from a table where the sum of rows in a joined table is greater than a number?
- Generating time series between two dates in PostgreSQL
- How to ignore errors with psql \copy meta-command
- PostgreSQL 17: pg_upgrade on Windows Server 2019: could not load library "$libdir/adminpack": No such file or directory
- How to restore postgres database into another database name
- Are PostgreSQL column names case-sensitive?
- PHP: exec() returns status '0' (successful) when executing failing PostgreSQL scripts
- Is TRUNCATE a DML statement?
- Initialize PostgreSQL Container with docker-entrypoint-initdb.d script
- pgadmin4 : postgresql application server could not be contacted
- Adding a raw select statement to the Knex query builder
- Gaps between primary key id in sql table
- MSB4057: The target "GetEFProjectMetadata" does not exist in the project. .NET Core 8, Entity Framework Core 8
- Prevent DateRangeField overlap in Django model?
- Ruby on Rails hashed password using BCrypt not saving to postgres users table
- Is it safe to set the statistics target to zero for numeric columns?
- Use multiple conflict_target in ON CONFLICT clause
- Retrieve similarity score in Python for HNSW vector indexing in PostgreSQL
- Sequelize is chopping of nested key length
- How to allow mixed integer and numeric parameters in icase
- PostgreSQL copy command using STDIN
- Error when Loading data into postgresql db
- pg_upgrade on Windows cannot write to log file pg_upgrade_internal.log
- Pivoting a table using crosstab() in PostgreSQL
- Getting error recursive reference to query must not appear within its non-recursive term in postgres
- dspace import metadata acknowledges changes doesn't apply them
- Running the Postgres CLI client from a Kubernetes jumpbox
- Problem Restoring PostgreSQL Database in Docker Container with Symfony
- Postgres split time ranges into 1 minute slots, without rounding boundaries
- how to store PostgreSQL jsonb using SpringBoot + JPA?