MIME-Version: 1.0
From: Edwin UY <edwin.uy@gmail.com>
Date: Mon, 3 Feb 2025 01:52:21 +1300
Message-ID: 
 <CA+wokJ-qqgzP5YnsSHkJRZxSxA20BZnWqgJfkuZhJdUDVacQUA@mail.gmail.com>
Subject: Parameter Settings - Instance-Database-Specific
To: pgsql-admin@lists.postgresql.org
Content-Type: multipart/alternative; boundary="0000000000004d6505062d2841d9"
Archived-At: 
 <https://www.postgresql.org/message-id/CA%2BwokJ-qqgzP5YnsSHkJRZxSxA20BZnWqgJfkuZhJdUDVacQUA%40mail.gmail.com>
Precedence: bulk

--0000000000004d6505062d2841d9
Content-Type: text/plain; charset="UTF-8"

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    |           |          |
 unit            | text    |           |          |
 category        | text    |           |          |
 short_desc      | text    |           |          |
 extra_desc      | text    |           |          |
 context         | text    |           |          |
 vartype         | text    |           |          |
 source          | text    |           |          |
 min_val         | text    |           |          |
 max_val         | text    |           |          |
 enumvals        | text[]  |           |          |
 boot_val        | text    |           |          |
 reset_val       | text    |           |          |
 sourcefile      | text    |           |          |
 sourceline      | integer |           |          |
 pending_restart | boolean |           |          |


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

--0000000000004d6505062d2841d9
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: base64

PGRpdiBkaXI9Imx0ciI+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6bW9ub3NwYWNlIj5I
aSw8L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6bW9ub3NwYWNlIj48
YnI+PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9zcGFjZSI+
SSBoYXZlIFBvc3RncmVTUUwgSW5zdGFuY2UgdGhhdCBoYXMgc2V2ZXJhbCBEQnMuPC9zcGFuPjwv
ZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9zcGFjZSI+SSBhc3N1bWUgdGhl
cmUgYXJlIGluc3RhbmNlIHNwZWNpZmljIGFuZCBkYXRhYmFzZSBzcGVjaWZpYyBwYXJhbWV0ZXIg
c2V0dGluZ3M/PGJyPjwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTpt
b25vc3BhY2UiPkhvdyBkbyBJIGNoZWNrIHRoaXM/IFVzaW5nIHRoZSBzb3VyY2UgY29sdW1uIG9m
IHBnX3NldHRpbmc/PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1v
bm9zcGFjZSI+SXMgdGhpcyB0cnVlIGZvciBib3RoIEF1cm9yYSBQb3N0Z3JlU1FMIC8gUkRTIGFu
ZCBub24tQVdTIFBvc3RncmVTUUw/PGJyPjwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJm
b250LWZhbWlseTptb25vc3BhY2UiPjxicj48L3NwYW4+PC9kaXY+PGRpdj48c3BhbiBzdHlsZT0i
Zm9udC1mYW1pbHk6bW9ub3NwYWNlIj49Jmd0OyBcZCBwZ19zZXR0aW5nczxicj48L3NwYW4+PC9k
aXY+PGRpdj48c3BhbiBzdHlsZT0iZm9udC1mYW1pbHk6bW9ub3NwYWNlIj7CoCDCoCDCoCDCoCDC
oCDCoCDCoMKgIFZpZXcgJnF1b3Q7cGdfY2F0YWxvZy5wZ19zZXR0aW5ncyZxdW90Ozxicj7CoCDC
oCDCoENvbHVtbiDCoCDCoCDCoHwgwqBUeXBlIMKgIHwgQ29sbGF0aW9uIHwgTnVsbGFibGUgfCBE
ZWZhdWx0PGJyPi0tLS0tLS0tLS0tLS0tLS0tKy0tLS0tLS0tLSstLS0tLS0tLS0tLSstLS0tLS0t
LS0tKy0tLS0tLS0tLTxicj7CoG5hbWUgwqAgwqAgwqAgwqAgwqAgwqB8IHRleHQgwqAgwqB8IMKg
IMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgwqB8PGJyPsKgc2V0dGluZyDCoCDCoCDCoCDCoCB8
IHRleHQgwqAgwqB8IMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgwqB8PGJyPsKgdW5pdCDC
oCDCoCDCoCDCoCDCoCDCoHwgdGV4dCDCoCDCoHwgwqAgwqAgwqAgwqAgwqAgfCDCoCDCoCDCoCDC
oCDCoHw8YnI+wqBjYXRlZ29yeSDCoCDCoCDCoCDCoHwgdGV4dCDCoCDCoHwgwqAgwqAgwqAgwqAg
wqAgfCDCoCDCoCDCoCDCoCDCoHw8YnI+wqBzaG9ydF9kZXNjIMKgIMKgIMKgfCB0ZXh0IMKgIMKg
fCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIMKgfDxicj7CoGV4dHJhX2Rlc2MgwqAgwqAg
wqB8IHRleHQgwqAgwqB8IMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgwqB8PGJyPsKgY29u
dGV4dCDCoCDCoCDCoCDCoCB8IHRleHQgwqAgwqB8IMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAg
wqAgwqB8PGJyPsKgdmFydHlwZSDCoCDCoCDCoCDCoCB8IHRleHQgwqAgwqB8IMKgIMKgIMKgIMKg
IMKgIHwgwqAgwqAgwqAgwqAgwqB8PGJyPsKgc291cmNlIMKgIMKgIMKgIMKgIMKgfCB0ZXh0IMKg
IMKgfCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIMKgfDxicj7CoG1pbl92YWwgwqAgwqAg
wqAgwqAgfCB0ZXh0IMKgIMKgfCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIMKgfDxicj7C
oG1heF92YWwgwqAgwqAgwqAgwqAgfCB0ZXh0IMKgIMKgfCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKg
IMKgIMKgIMKgfDxicj7CoGVudW12YWxzIMKgIMKgIMKgIMKgfCB0ZXh0W10gwqB8IMKgIMKgIMKg
IMKgIMKgIHwgwqAgwqAgwqAgwqAgwqB8PGJyPsKgYm9vdF92YWwgwqAgwqAgwqAgwqB8IHRleHQg
wqAgwqB8IMKgIMKgIMKgIMKgIMKgIHwgwqAgwqAgwqAgwqAgwqB8PGJyPsKgcmVzZXRfdmFsIMKg
IMKgIMKgIHwgdGV4dCDCoCDCoHwgwqAgwqAgwqAgwqAgwqAgfCDCoCDCoCDCoCDCoCDCoHw8YnI+
wqBzb3VyY2VmaWxlIMKgIMKgIMKgfCB0ZXh0IMKgIMKgfCDCoCDCoCDCoCDCoCDCoCB8IMKgIMKg
IMKgIMKgIMKgfDxicj7CoHNvdXJjZWxpbmUgwqAgwqAgwqB8IGludGVnZXIgfCDCoCDCoCDCoCDC
oCDCoCB8IMKgIMKgIMKgIMKgIMKgfDxicj7CoHBlbmRpbmdfcmVzdGFydCB8IGJvb2xlYW4gfCDC
oCDCoCDCoCDCoCDCoCB8IMKgIMKgIMKgIMKgIMKgfDxicj48YnI+PGJyPjwvc3Bhbj48L2Rpdj48
ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTptb25vc3BhY2UiPnNlbGVjdCBkaXN0aW5jdCBz
b3VyY2UgZnJvbSBwZ19zZXR0aW5ncyA7PGJyPsKgIMKgIMKgIMKgc291cmNlPGJyPi0tLS0tLS0t
LS0tLS0tLS0tLS0tPGJyPsKgY2xpZW50PGJyPsKgY29uZmlndXJhdGlvbiBmaWxlPGJyPsKgZGVm
YXVsdDxicj7CoGRhdGFiYXNlPGJyPsKgb3ZlcnJpZGU8YnI+wqBjb21tYW5kIGxpbmU8YnI+KDYg
cm93cyk8YnI+PC9zcGFuPjwvZGl2PjxkaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9z
cGFjZSI+PGJyPjwvc3Bhbj48L2Rpdj48ZGl2PjxzcGFuIHN0eWxlPSJmb250LWZhbWlseTptb25v
c3BhY2UiPjxicj48L3NwYW4+PC9kaXY+PHNwYW4gc3R5bGU9ImZvbnQtZmFtaWx5Om1vbm9zcGFj
ZSI+PGJyPjwvc3Bhbj48L2Rpdj4NCg==
--0000000000004d6505062d2841d9--