| From: | "cesar" <caerices(at)gmail(dot)com> |
|---|---|
| To: | "ayuda Postgres" <pgsql-es-ayuda(at)postgresql(dot)org> |
| Subject: | Consulta |
| Date: | 2006-01-15 20:33:27 |
| Message-ID: | 43cab19a.092f47c7.1565.ffffd54d@mx.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-es-ayuda |
Hola amigo tengo una consulta sobre porque se puede haber bloqueado una base
de datos postgres version 8.0, corre sobre Windows, y antes de colgarse se
produjo un corte de luz en el momento que habían aproximadamente 20 usuarios
conectados, el corte fue general y duro aproximadamente 20 minutos al
momento de reactivar el servidor la base de datos no respondió más acusando
e error: que la conexión fue rechazada por no encontrarse la conexión con el
localhost (127.0.0.1); yo coloque el log para que indicara todas las
transacciones y lo ultimo que escribió fue:
2006-01-13 17:43:39 LOG: unexpected EOF on client connection
2006-01-13 17:46:00 LOG: received fast shutdown request
2006-01-13 17:46:00 LOG: aborting any active transactions
2006-01-13 17:46:00 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:01 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:01 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:02 FATAL: terminating connection due to administrator
command
2006-01-13 17:46:03 LOG: checkpoints are occurring too frequently (0
seconds apart)
2006-01-13 17:46:03 HINT: Consider increasing the configuration parameter
"checkpoint_segments".
2006-01-13 17:46:06 LOG: shutting down
2006-01-13 17:46:07 LOG: database system is shut down
2006-01-13 17:46:09 LOG: logger shutting down
Acepto todo tipo de sugerencia para evitar este problema.
Gracias, Cesar Erices
IQUIQUE - CHILE
| From | Date | Subject | |
|---|---|---|---|
| Next Message | ruben avila galindo | 2006-01-15 22:39:44 | AYUDA CON MODELAMIENTO DE LA BD |
| Previous Message | Mario Gonzalez | 2006-01-15 19:23:00 | Re: Mondrian y postgresql |