From: Tom Lane <tgl@sss.pgh.pa.us>
To: Ron Johnson <ronljohnsonjr@gmail.com>
cc: Edwin UY <edwin.uy@gmail.com>,
        Pgsql-admin <pgsql-admin@lists.postgresql.org>
Subject: Re: Parameter Settings - Instance-Database-Specific
In-reply-to: 
 <CANzqJaCP0C63feoHBG-jCG_=MWrzhs6jNykANf_KrUHTtbuw+g@mail.gmail.com>
References: 
 <CA+wokJ-qqgzP5YnsSHkJRZxSxA20BZnWqgJfkuZhJdUDVacQUA@mail.gmail.com>
 <CANzqJaCP0C63feoHBG-jCG_=MWrzhs6jNykANf_KrUHTtbuw+g@mail.gmail.com>
Comments: In-reply-to Ron Johnson <ronljohnsonjr@gmail.com>
	message dated "Sun, 02 Feb 2025 09:57:06 -0500"
MIME-Version: 1.0
Content-Type: text/plain; charset="UTF-8"
Content-ID: <351637.1738509545.1@sss.pgh.pa.us>
Content-Transfer-Encoding: 8bit
Date: Sun, 02 Feb 2025 10:19:05 -0500
Message-ID: <351638.1738509545@sss.pgh.pa.us>
Archived-At: 
 <https://www.postgresql.org/message-id/351638.1738509545%40sss.pgh.pa.us>
Precedence: bulk

Ron Johnson <ronljohnsonjr@gmail.com> writes:
> On Sun, Feb 2, 2025 at 7:53 AM Edwin UY <edwin.uy@gmail.com> 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