Обсуждение: Postgresql not getting assigned memory

Am 2014-06-20 13:51, schrieb Oliver:
[...]

When I restart instance or even server, pgstartup.log indicates:

seleccionando el valor para shared_buffers ... 128MB (I'm sorry, I'm
spanish and server is configured in spanish). But it shows something
as: selecting shared_buffers value ... 128MB.

set lc_messages = 'C' in postgresql.conf to get english logs.

What version of postgres is this? If it's is lower than 9.3 you might need to read this:
http://www.postgresql.org/docs/9.2/static/kernel-resources.html

hth

Jan


--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin

Hello,

I'm new in postgresql, I'm sorry if I do something bad.

Default value or shared_buffers is 128MB, I have a dedicated server for postgresql with 8GB RAM. I've changed shared_buffers value to 2048MB and uncommented the entry in postgresql.conf. It shows now:

# - Memory -

shared_buffers = 2048MB                 # min 128kB

When I restart instance or even server, pgstartup.log indicates:

seleccionando el valor para shared_buffers ... 128MB (I'm sorry, I'm spanish and server is configured in spanish). But it shows something as: selecting shared_buffers value ... 128MB.

What I do bad? Thanks beforehand.

Cheers...

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

Hi,

Can you please check the output of below command:

postgres=# show shared_buffers ;

Thanks & Regards,

Abdul Sayeed

System Engineer

The Postgres Database Company

Are you updated: Latest version of Postgres Plus Advanced Server are 8.4.19.42, 9.0.16.34, 9.1.12.20, 9.2.8.19 and 9.3.4.10

To reach Support Call:

US: +1-732-331-1320  - UK: +44 - 2033719820

Brazil: +55-2139581371 - India: +91-20-32676535

Website: www.enterprisedb.com

EnterpriseDB Blog : http://blogs.enterprisedb.com

Follow us on Twitter : http://www.twitter.com/enterprisedb

____________________________________________________________

CONFIDENTIALITY NOTICE

This e-mail transmission and any documents, files, or previous e-mail messages appended or attached to it, may contain information that is confidential or legally privileged. If you are not the intended recipient, or a person responsible for delivering it to the intended recipient, you are hereby notified that you must not read this transmission and that any disclosure, copying, printing, distribution, or use of the information contained or attached to this transmission is STRICTLY PROHIBITED. If you have received this transmission in error, please immediately notify the sender by telephone or return e-mail message and delete the original transmission, its attachments, and any copies without reading or saving in any manner. Thank you.

On Fri, Jun 20, 2014 at 5:21 PM, Oliver <ofabelo@gmail.com> wrote:

Hello,

I'm new in postgresql, I'm sorry if I do something bad.

Default value or shared_buffers is 128MB, I have a dedicated server for postgresql with 8GB RAM. I've changed shared_buffers value to 2048MB and uncommented the entry in postgresql.conf. It shows now:

# - Memory -

shared_buffers = 2048MB                 # min 128kB

When I restart instance or even server, pgstartup.log indicates:

seleccionando el valor para shared_buffers ... 128MB (I'm sorry, I'm spanish and server is configured in spanish). But it shows something as: selecting shared_buffers value ... 128MB.

What I do bad? Thanks beforehand.

Cheers...

On Fri, Jun 20, 2014 at 4:51 AM, Oliver <ofabelo@gmail.com> wrote:
> Hello,
> I'm new in postgresql, I'm sorry if I do something bad.
> Default value or shared_buffers is 128MB, I have a dedicated server for
> postgresql with 8GB RAM. I've changed shared_buffers value to 2048MB and
> uncommented the entry in postgresql.conf. It shows now:
>
> # - Memory -
>
> shared_buffers = 2048MB                 # min 128kB
>
> When I restart instance or even server, pgstartup.log indicates:
>
> seleccionando el valor para shared_buffers ... 128MB (I'm sorry, I'm spanish
> and server is configured in spanish). But it shows something as: selecting
> shared_buffers value ... 128MB.
> What I do bad? Thanks beforehand.

That message comes from initdb.  initdb should not be run when you
restart the database or the server, but only when you create a new
database cluster.  Perhaps you are looking at an old log file, not a
new one.  Or perhaps you have accidentally created more than one
database cluster on your server (i.e. more than one data directory).

The file "pgstartup.log" is not something that PostgreSQL itself
creates.  It may be part of the PostgreSQL start-up scripts
distributed by the packager.  What repository did you use to install
PostgreSQL?

Cheers,

Jeff