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