Re: Parameter Settings - Instance-Database-Specific

Hi,

I have PostgreSQL Instance that has several DBs.

I assume there are instance specific and database specific parameter settings?

How do I check this? Using the source column of pg_setting?

Is this true for both Aurora PostgreSQL / RDS and non-AWS PostgreSQL?

=> \d pg_settings

               View "pg_catalog.pg_settings"
     Column      |  Type   | Collation | Nullable | Default
-----------------+---------+-----------+----------+---------
 name            | text    |           |          |
 setting         | text    |           |          |

select distinct source from pg_settings ;
       source
--------------------
 client
 configuration file
 default
 database
 override
 command line
(6 rows)