Search Postgresql Archives

Re: Postgresql not getting assigned memory

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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.janes@xxxxxxxxx>:
On Fri, Jun 20, 2014 at 4:51 AM, Oliver <ofabelo@xxxxxxxxx> 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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux