Determine if Postgres is running on AWS RDS
I found 3 ways to check if the current instance of Postgres is running on AWS
select * from pg_settings where name like 'rds.%';
select * from pg_settings where name like 'aurora%';
select spcname from pg_tablespace where spcname like 'aurora%';Using the first method to check for any settings that start with rds.
select * from pg_settings where name like 'rds.%'Returns around 40 rows that look like this
| name | settings |
|---|---|
| rds.global_db_rpo | -1 |
| rds.internal_databases | rdsadmin |
The second method is pretty much the same as the first but you'll get less rows back, around 9.
select * from pg_settings where name like 'aurora%';| name | settings |
|---|---|
| aurora_compute_plan_id | on |
| aurora_stat_plans.calls_until_recapture | 0 |
| aurora_stat_plans.with_triggers | off |
The final method is to check if there are any tablespaces that are specific to AWS
select spcname from pg_tablespace where spcname like 'aurora%';| spcname |
|---|
| aurora_temp_tablespace |
I'm sure there are more ways but this should work for me. If you know of any others feel free to reach out and I'll add them.
