Re: Postgresql not getting assigned memory

From: Oliver <ofabelo(at)gmail(dot)com>
To: Kevin Grittner <kgrittn(at)ymail(dot)com>
Cc: Jan Lentfer <Jan(dot)Lentfer(at)web(dot)de>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Postgresql not getting assigned memory
Date: 2014-06-20 12:55:22
Message-ID: CALQkqm-ni-3UtBUrGJmeq-pr2+2As4YZeMgMzN8BO5pE_s1uuQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

Thanks.
It is 9.3.4 on x86_64-unknown-linux-gnu.
Service can start perfectly. I only want be sure about shared_buffers
parameter. What I set there, is it memory that postgresql will use (will
allocate) initially (when it is started) or memory until that postgresql
can reach of the server?
Thanks.

Cheers...

2014-06-20 13:46 GMT+01:00 Kevin Grittner <kgrittn(at)ymail(dot)com>:

> Oliver <ofabelo(at)gmail(dot)com> wrote:
>
> > $ more PG_VERSION
> > 9.3
>
> If you can start the databased service and connect to it, the best
> way to check the version is:
>
> SELECT version();
>
> If you can't start the service, you can do this:
>
> $ postgres --version
>
> (You may need to specify the path to the postgres executable.)
>
> Either way you should be able to determine the minor release. It
> is always a good idea to keep up-to-date on minor releases (where
> the version number only changes to the right of the second dot),
> because in PostgreSQL we only include fixes for serious bugs and
> security vulnerabilities in minor releases, not new features. See
> this page for additional discussion of the issue:
>
> http://www.postgresql.org/support/versioning/
>
> This is even more important than usual for 9.3, which had some data
> corruption bugs in early versions.
>
> --
> Kevin Grittner
> EDB: http://www.enterprisedb.com
> The Enterprise PostgreSQL Company
>

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Oliver 2014-06-20 12:58:34 Re: Postgresql not getting assigned memory
Previous Message Abdul Sayeed 2014-06-20 12:54:51 Re: Postgresql not getting assigned memory

Browse pgsql-general by date

  From Date Subject
Next Message Oliver 2014-06-20 12:58:34 Re: Postgresql not getting assigned memory
Previous Message Abdul Sayeed 2014-06-20 12:54:51 Re: Postgresql not getting assigned memory