Re: [GENERAL] Postgresql not getting assigned memory

From: Jeff Janes <jeff(dot)janes(at)gmail(dot)com>
To: Oliver <ofabelo(at)gmail(dot)com>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>, Forums postgresql <pgsql-general(at)postgresql(dot)org>
Subject: Re: [GENERAL] Postgresql not getting assigned memory
Date: 2014-06-20 16:13:49
Message-ID: CAMkU=1xVou-B5ydHRXGCT9bU4xsTAXnSAwuaqQR34cusmVCt5A@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

On Fri, Jun 20, 2014 at 4:51 AM, Oliver <ofabelo(at)gmail(dot)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

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message John Scalia 2014-06-20 17:44:50 Cannot rebuild a standby server
Previous Message Kevin Grittner 2014-06-20 13:14:10 Re: Postgresql not getting assigned memory

Browse pgsql-general by date

  From Date Subject
Next Message Jonathan Vanasco 2014-06-20 19:10:48 Re: How to store fixed size images?
Previous Message Steve Crawford 2014-06-20 15:23:26 Re: Strange Error in postgresql 8.4