| From: | Jaime Casanova <jaime(at)2ndquadrant(dot)com> |
|---|---|
| To: | Harold Alexander Onore Harold <onoreharold(at)gmail(dot)com> |
| Cc: | Lista PostgreSQL en Español <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: shared_buffers |
| Date: | 2011-05-09 14:05:19 |
| Message-ID: | BANLkTimCHjBBvvDbtc6HhTovhPqNkNeAxA@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
2011/5/9 Harold Alexander Onore Harold <onoreharold(at)gmail(dot)com>:
> Saludos,
>
> Me puse a modificar el shared_buffers de mi maquina y lo lleve a
> (shared_buffers = 64MB) al intentar arrarcar el servicio del gestor de base
> de datos me da un error que es el siguiente:
>
> the request size or reconfigure the kernel with larger SHMMAX. To reduce
> the request size (currently 72220672 bytes), reduce PostgreSQL's
> shared_buffers parameter (currently 8192) and/or its max_connections
> parameter (currently 103). If the request size is already small, it's
> possible that it is less than your kernel's SHMMIN parameter, in which case
> raising the request size or reconfiguring SHMMIN is called for. The
> PostgreSQL documentation contains more information about shared memory
> configuration.
>
La variable shmmax esta muy baja en el SO y debes aumentarla, lee aqui
http://www.postgresql.org/docs/9.0/static/kernel-resources.html#SYSVIPC
busca tu sistema operativo y sigue los pasos
--
Jaime Casanova www.2ndQuadrant.com
Professional PostgreSQL: Soporte y capacitación de PostgreSQL
| From | Date | Subject | |
|---|---|---|---|
| Next Message | yapt | 2011-05-09 14:10:25 | [OT] - Estrategia de tablas (red social -muchos a muchos-). |
| Previous Message | Álvaro Hernández Tortosa | 2011-05-09 14:00:36 | Re: shared_buffers |