On Wed, Oct 30, 2024 at 11:49:29AM -0400, Ron Johnson wrote:
> Settings, like "SELECT * FROM pg_settings;"
This query will show you the non-default settings:
SELECT name, current_setting(name), source
FROM pg_settings
WHERE source NOT IN ('default', 'override');
---------------------------------------------------------------------------
> On Wed, Oct 30, 2024 at 11:32 AM alexander al (leiden) <alexander@xxxxxxxx>
> wrote:
>
> Hi,
>
> we have a supplier (via our client) who has an self build PAAS-version
> of postgresql. Ok, you would say, that's fine. But, there is always an
> but, we think the settings are not quite ok. We really want to know how
> much memory etc there is on that server. So we can recommend the
> recommended settings. Is there a way to get those information on the
> server itself from psql?
>
> regards,
>
> Alexander Al
>
>
>
>
>
>
>
> --
> Death to <Redacted>, and butter sauce.
> Don't boil me, I'm still alive.
> <Redacted> crustacean!
--
Bruce Momjian <bruce@xxxxxxxxxx> https://momjian.us
EDB https://enterprisedb.com
When a patient asks the doctor, "Am I going to die?", he means
"Am I going to die soon?"
