Re: Postgresql not getting assigned memory

Hi,
thanks for replying.
Yes, I've seen that information in that file was introduced by initdb
initially. When I restart the server/PGSQL it appends/adds information to
that file, wihout modifying information that was introduced initially by
initdb .. so I'm sure that initdb was executed only once.
I'm using official repository of PGSQL for Red Hat 6.5 (
http://yum.postgresql.org/9.3/redhat/rhel-6.5-x86_64/), I've followed
official steps indicated here:
http://www.postgresql.org/download/linux/redhat/
For finishing this thread then, I will think that all is ok, "show
shared_buffers" query shows 2GB in psql, and system has little memory used
due to inactivity of database and it will go reaching more when database
has connections.
Thanks for all.

Cheers...

2014-06-20 17:13 GMT+01:00 Jeff Janes <jeff(dot)janes(at)gmail(dot)com>:

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