public inbox for [email protected]
help / color / mirror / Atom feedParameter Settings - Instance-Database-Specific
3+ messages / 3 participants
[nested] [flat]
* Parameter Settings - Instance-Database-Specific
@ 2025-02-02 12:52 Edwin UY <[email protected]>
2025-02-02 14:57 ` Re: Parameter Settings - Instance-Database-Specific Ron Johnson <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Edwin UY @ 2025-02-02 12:52 UTC (permalink / raw)
To: [email protected]
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)
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Parameter Settings - Instance-Database-Specific
2025-02-02 12:52 Parameter Settings - Instance-Database-Specific Edwin UY <[email protected]>
@ 2025-02-02 14:57 ` Ron Johnson <[email protected]>
2025-02-02 15:19 ` Re: Parameter Settings - Instance-Database-Specific Tom Lane <[email protected]>
0 siblings, 1 reply; 3+ messages in thread
From: Ron Johnson @ 2025-02-02 14:57 UTC (permalink / raw)
To: Pgsql-admin <[email protected]>
On Sun, Feb 2, 2025 at 7:53 AM Edwin UY <[email protected]> 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!
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: Parameter Settings - Instance-Database-Specific
2025-02-02 12:52 Parameter Settings - Instance-Database-Specific Edwin UY <[email protected]>
2025-02-02 14:57 ` Re: Parameter Settings - Instance-Database-Specific Ron Johnson <[email protected]>
@ 2025-02-02 15:19 ` Tom Lane <[email protected]>
0 siblings, 0 replies; 3+ messages in thread
From: Tom Lane @ 2025-02-02 15:19 UTC (permalink / raw)
To: Ron Johnson <[email protected]>; +Cc: Edwin UY <[email protected]>; Pgsql-admin <[email protected]>
Ron Johnson <[email protected]> writes:
> On Sun, Feb 2, 2025 at 7:53 AM Edwin UY <[email protected]> wrote:
>> 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?
> 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.
More precisely, it shows you the values that prevail at this moment
in your own session. You can tell where those values came from
via the "source" column, but it won't tell you anything about
values that might've been locally overridden.
I think psql's "\drds" command might be what Edwin is looking for.
>> Is this true for both Aurora PostgreSQL / RDS and non-AWS PostgreSQL?
[ shrug... ] Most people on this list only know about community
Postgres. You'd have to ask AWS whether Aurora differs in this
area.
regards, tom lane
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2025-02-02 15:19 UTC | newest]
Thread overview: 3+ messages (download: mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2025-02-02 12:52 Parameter Settings - Instance-Database-Specific Edwin UY <[email protected]>
2025-02-02 14:57 ` Ron Johnson <[email protected]>
2025-02-02 15:19 ` Tom Lane <[email protected]>
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox