MIME-Version: 1.0
References: <aac85bb09a0cb27eb88075d1f6988e3fb7d3483f.camel@scred.nl>
In-Reply-To: <aac85bb09a0cb27eb88075d1f6988e3fb7d3483f.camel@scred.nl>
From: Ian Lawrence Barwick <barwick@gmail.com>
Date: Fri, 1 Nov 2024 15:07:20 +0900
Message-ID: <CAB8KJ=hLMRE6=bkQV0bpgozrxjkECKjoGsbjH63U=85woKrDJw@mail.gmail.com>
Subject: Re: What to do with a PAAS-pg server
To: "alexander al (leiden)" <alexander@scred.nl>
Cc: Postgres General <pgsql-general@postgresql.org>
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable
Archived-At: <https://www.postgresql.org/message-id/CAB8KJ%3DhLMRE6%3DbkQV0bpgozrxjkECKjoGsbjH63U%3D85woKrDJw%40mail.gmail.com>
Precedence: bulk

2024=E5=B9=B410=E6=9C=8831=E6=97=A5(=E6=9C=A8) 0:32 alexander al (leiden) <=
alexander@scred.nl>:
>
> 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?

If you mean you e.g. only have access to psql on the server in question,
but want to know more about the server itself (i.e. not the PostgreSQL
settings), then you might have luck poking around with the pg_read_file()
function, e.g.:

    SELECT pg_read_file('/proc/meminfo');

Note you will need database superuser permission to execute pg_read_file(),
or for non-superusers be granted EXECUTE permission on it.

Regards

Ian Barwick