Request a Demo
Home   >   mailing lists

Re: Parameter Settings - Instance-Database-Specific - Mailing list pgsql-admin

From Ron Johnson
Subject Re: Parameter Settings - Instance-Database-Specific
Date
Msg-id CANzqJaCP0C63feoHBG-jCG_=MWrzhs6jNykANf_KrUHTtbuw+g@mail.gmail.com
Whole thread Raw
In response to Parameter Settings - Instance-Database-Specific  (Edwin UY <edwin.uy@gmail.com>)
Responses Re: Parameter Settings - Instance-Database-Specific
List pgsql-admin
Tree view
On Sun, Feb 2, 2025 at 7:53 AM Edwin UY <edwin.uy@gmail.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!

pgsql-admin by date:

Previous
From: Edwin UY
Date:
Subject: Parameter Settings - Instance-Database-Specific
Next
From: Tom Lane
Date:
Subject: Re: Parameter Settings - Instance-Database-Specific