Re: Postgresql not getting assigned memory - Mailing list pgsql-admin

From Oliver
Subject Re: Postgresql not getting assigned memory
Date
Msg-id CALQkqm-ni-3UtBUrGJmeq-pr2+2As4YZeMgMzN8BO5pE_s1uuQ@mail.gmail.com
Whole thread Raw
In response to Re: Postgresql not getting assigned memory  (Kevin Grittner <kgrittn@ymail.com>)
Responses Re: Postgresql not getting assigned memory
List pgsql-admin
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@ymail.com>:
Oliver <ofabelo@gmail.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

pgsql-admin by date:

Previous
From: Abdul Sayeed
Date:
Subject: Re: [GENERAL] Postgresql not getting assigned memory
Next
From: Oliver
Date:
Subject: Re: [GENERAL] Postgresql not getting assigned memory