| From: | Rensi Arteaga Copari <rarteaga(at)ende(dot)bo> |
|---|---|
| To: | Ayuda <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Re: fatal out of shared memory postgres |
| Date: | 2010-09-17 20:19:27 |
| Message-ID: | 4C93CD4F.6000207@ende.bo |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Lo siento, especificando mejor:
El error completo dice
Unable to connect to PostgreSQL server:
FATAL: out of shared memory HINT: You may need to increase
max_locks_per_transacction, in
/opt/lampp/htdocs/endesis/cls_conexion.php on line 57
arodriguez fallo
tengo 60 usuarios recurrentes y aumentando..
8 G de RAM
2 procesadores de cuatro núcleos cada uno de 2.2 GHZ
shared_buffers = 327680 # min 16 or max_connections*2,
8KB each 1000
temp_buffers = 100000 # min 100, 8KB each
#max_prepared_transactions = 5 # can be 0 or more
# note: increasing max_prepared_transactions costs ~600 bytes of shared
memory
# per transaction slot, plus lock space (see max_locks_per_transaction).
work_mem = 102400 # min 64, size in KB 1024
maintenance_work_mem = 524288
max_connections = 100
--
EMPRESA NACIONAL DE ELECTRICIDAD
www.ende.bo
Tel.: (591-4) 4520317 - 4120900
Fax: (591-4) 4520318
---------------------------------------------------------------------------------
Este mensaje ha sido analizado automaticamente por el MailScanner de ENDE
y no han sido detectados virus ni otros contenidos peligrosos.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Moises Alberto Lindo Gutarra | 2010-09-17 21:20:58 | Re: campo bytea en postgres 9.0 |
| Previous Message | juanramirez | 2010-09-17 20:10:10 | Re: campo bytea en postgres 9.0 |