On Sun, Feb 2, 2025 at 7:53 AM Edwin UY <edwin.uy@xxxxxxxxx> wrote:
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_settingsView "pg_catalog.pg_settings"
Column | Type | Collation | Nullable | Default
-----------------+---------+-----------+----------+---------
name | text | | |
setting | text | | |
[snip]
select distinct source from pg_settings ;
source
--------------------
client
configuration file
default
database
override
command line
(6 rows)
What do you get when you run:
SELECT * FROM pg_setting WHERE source = ''database';
More important, though, is the fact that pg_settings does not have a "datname" column. Thus, it's values are all global to the instance.
Death to <Redacted>, and butter sauce.
Don't boil me, I'm still alive.
<Redacted> lobster!
