public inbox for [email protected]  

help / color / mirror / Atom feed

From: Ian Lawrence Barwick <[email protected]>
To: alexander al (leiden) <[email protected]>
Cc: Postgres General <[email protected]>
Subject: Re: What to do with a PAAS-pg server
Date: Fri, 1 Nov 2024 15:07:20 +0900
Message-ID: <CAB8KJ=hLMRE6=bkQV0bpgozrxjkECKjoGsbjH63U=85woKrDJw@mail.gmail.com> (raw)
In-Reply-To: <[email protected]>
References: <[email protected]>

2024年10月31日(木) 0:32 alexander al (leiden) <[email protected]>:
>
> 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

view thread (4+ messages)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: What to do with a PAAS-pg server
  In-Reply-To: <CAB8KJ=hLMRE6=bkQV0bpgozrxjkECKjoGsbjH63U=85woKrDJw@mail.gmail.com>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox