Thread: What to do with a PAAS-pg server

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

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@scred.nl>
> 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@momjian.us>        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?"

2024年10月31日(木) 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