Re: Parameter Settings - Instance-Database-Specific

On Sun, Feb 2, 2025 at 7:53 AM Edwin UY <edwin(dot)uy(at)gmail(dot)com> 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_settings
> View "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!