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/
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 |