Ayuda postgresql windows!!!

From: "ALFREDO ALARCON" <alfalar(at)gmail(dot)com>
To: pgsql-es-ayuda(at)postgresql(dot)org
Subject: Ayuda postgresql windows!!!
Date: 2006-11-06 19:28:59
Message-ID: ad0122e80611061128i14307496g55b9eb27324b1b9c@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Buen día!!!
Tengo un problema con postgresql en su version windows y quisiera saber si
alguien me puede dar una luz. El problema es el siguiente:
Tengo un sistema que esta llenando una tabla de la base de datos
aproximadamente en 300000 registros al día, pero pasados 3 o 4 dias la base
de datos me da problemas de lentitud y debo empezar a borrarle registros a
la tabla. La tabla tiene indices (btree y gist, pues es una tabla
geografico) y se le hace vacumm analize seguido. El otro problema se me
presento esta semana, el servicio de base de datos se cayo y ya no subio
mas. El log que me dejo fue el siguiente:
2006-11-04 20:37:16 LOG: database system was interrupted while in recovery
at 2006-11-04 20:37:09 Hora est. de América Central
2006-11-04 20:37:16 HINT: This probably means that some data is corrupted
and you will have to use the last backup for recovery.
2006-11-04 20:37:16 LOG: checkpoint record is at A/542596F0
2006-11-04 20:37:16 LOG: redo record is at A/5421D588; undo record is at
0/0; shutdown FALSE
2006-11-04 20:37:16 LOG: next transaction ID: 91511486; next OID: 33784
2006-11-04 20:37:16 LOG: next MultiXactId: 1; next MultiXactOffset: 0
2006-11-04 20:37:16 LOG: database system was not properly shut down;
automatic recovery in progress
2006-11-04 20:37:16 LOG: redo starts at A/5421D588
2006-11-04 20:37:16 PANIC: could not access status of transaction 0
2006-11-04 20:37:16 DETAIL: could not write to file "pg_clog/0057" at offset
73728: No space left on device

This application has requested the Runtime to terminate it in an unusual
way.
Please contact the application's support team for more information.
2006-11-04 20:37:16 LOG: startup process (PID 1348) was terminated by signal
3
2006-11-04 20:37:16 LOG: aborting startup due to startup process failure
2006-11-04 20:37:17 LOG: logger shutting down

Agradezco su ayuda

--
Alfredo Alarcón

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message darkglam darkglam 2006-11-06 19:43:53 Re: Ayuda postgresql windows!!!
Previous Message Fernanda Fueltala 2006-11-06 19:21:28 Re: Error en funcion con OID