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
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 |
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 |