problema recolector de estadisticas

From: Alejandro Gasca <agasca(at)yahoo(dot)com>
To: ayuda postgres <pgsql-es-ayuda(at)postgresql(dot)org>
Subject: problema recolector de estadisticas
Date: 2006-08-29 18:17:29
Message-ID: 20060829181729.89699.qmail@web34310.mail.mud.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-es-ayuda

Hola, compile la version 8.1.4 en un sistema ubuntu.
Todo iba bien, pero cuando le active el autovacuum aparecio los
siguiente en el log:

2006-08-29 12:50:20.039 CDTLOG: could not receive test message on
socket for statistics collector: Connection refused
2006-08-29 12:50:20.039 CDTLOG: disabling statistics collector for
lack of working socket
2006-08-29 12:50:20.040 CDTLOG: database system was shut down at
2006-08-29 12:50:16 CDT
2006-08-29 12:50:20.040 CDTLOG: checkpoint record is at 0/AD07CE84
2006-08-29 12:50:20.040 CDTLOG: redo record is at 0/AD07CE84; undo
record is at 0/0; shutdown TRUE
2006-08-29 12:50:20.040 CDTLOG: next transaction ID: 220756; next OID:
18249
2006-08-29 12:50:20.040 CDTLOG: next MultiXactId: 1; next
MultiXactOffset: 0
2006-08-29 12:50:20.041 CDTWARNING: autovacuum not started because of
misconfiguration
2006-08-29 12:50:20.041 CDTHINT: Enable options
"stats_start_collector" and "stats_row_level".
2006-08-29 12:50:20.067 CDTLOG: database system is ready
2006-08-29 12:50:20.068 CDTLOG: transaction ID wrap limit is
1073747456, limited by database "basetablota"

En el postgresql.conf tengo:

listen_addresses= '*'
max_connections = 100
superuser_reserved_connections = 4
log_rotation_size = 2000
log_line_prefix = '%m'
stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = true
autovacuum = on
lc_messages = 'es_MX.UTF-8'

lc_monetary = 'es_MX.UTF-8'
lc_numeric = 'es_MX.UTF-8'
lc_time = 'es_MX.UTF-8'

Y pues no se si tenga que darle algun permiso a alguna cosa...

De antemano, gracias.

Alejandro

__________________________________________________
Correo Yahoo!
Espacio para todos tus mensajes, antivirus y antispam ¡gratis!
Regístrate ya - http://correo.espanol.yahoo.com/

Responses

Browse pgsql-es-ayuda by date

  From Date Subject
Next Message crispin tolavi morales 2006-08-29 19:51:28 pgadmin
Previous Message Jaime Casanova 2006-08-29 12:44:29 Re: Error de conversion