RE: ayuda

haciendole un vacuum full analize me da esto

NFO: analyzing "public.tran_evento_programado"
INFO: "tran_evento_programado": scanned 1 of 1 pages, containing 5 live rows and 0 dead rows; 5 rows in sample, 5 estimated total rows
INFO: free space map: 215 relations, 13397 pages stored; 41552 total pages needed
DETALLE: Allocated FSM size: 1000 relations + 20000 pages = 182 kB shared memory.
WARNING: some databases have not been vacuumed in 1949927922 transactions
HINT: Better vacuum them within 197555725 transactions, or you may have a wraparound failure.

Total query runtime: 1288972 ms.
el backup da esto

/usr/bin/pg_dump -i -h 10.0.0.122 -p 5432 -U datafctry -F t -b -o -v -f "backup" datositio
pg_dump: leyendo esquemas
pg_dump: falló el comando SQL
pg_dump: Mensaje de error del servidor: ERROR: more than one row returned by a subquery used as an expression
pg_dump: El comando es: SELECT tableoid, oid, nspname, (SELECT usename FROM pg_catalog.pg_user WHERE usesysid = nspowner) as rolname, nspacl FROM pg_namespace
pg_dump: *** se abortó por un error

Process returned exit code 1.

-----Mensaje original-----
De: pgsql-es-ayuda-owner(at)postgresql(dot)org [mailto:pgsql-es-ayuda-owner(at)postgresql(dot)org]En nombre de Diego Barreto
Enviado el: Jueves, 02 de Agosto de 2007 11:57 a.m.
Para: pgsql-es-ayuda(at)postgresql(dot)org
Asunto: [pgsql-es-ayuda] ayuda
Importancia: Alta

como puedo hacer esto??

TRUNCATE pg_statistic;
VACUUM ANALYZE; -- rebuild contents of pg_statistic
VACUUM FREEZE; -- make sure template0 needs no further vacuuming

segun donde lo encontre dice asi

Fortunately for you, pg_statistic doesn't contain any irreplaceable
data. So you could get out of this via

conectado con el usuario postgres me da este error

template0=# TRUNCATE pg_statistic;
TRUNCATE pg_statistic;
ERROR: permission denied: "pg_statistic" is a system catalog
template0=#

tengo la base template0 duplicada no puedo hacer backups ni el VACUUM

template0=# VACUUM FREEZE;
VACUUM FREEZE;
WARNING: some databases have not been vacuumed in 1944943011 transactions
HINT: Better vacuum them within 202540636 transactions, or you may have a wraparound failure.
VACUUM

template0=# VACUUM ANALYZE;
VACUUM ANALYZE;
WARNING: some databases have not been vacuumed in 1944943098 transactions
HINT: Better vacuum them within 202540549 transactions, or you may have a wraparound failure.
VACUUM
template0=# select datname, age(datfrozenxid), datfrozenxid, current_date, current_time FROM pg_database;
select datname, age(datfrozenxid), datfrozenxid, current_date, current_time FROM pg_database;
datname | age | datfrozenxid | date | timetz
--------------+-------------+--------------+------------+--------------------
template0 | -1272184968 | 553 | 2007-08-02 | 12:04:07.589532+00
template0 | 1073741910 | 1949040971 | 2007-08-02 | 12:04:07.589532+00
template1 | 495 | 3022782386 | 2007-08-02 | 12:04:07.589532+00
sapo | 1944943099 | 1077839782 | 2007-08-02 | 12:04:07.589532+00
dbase | 1944942302 | 1077840579 | 2007-08-02 | 12:04:07.589532+00
datositio | 1073742448 | 1949040433 | 2007-08-02 | 12:04:07.589532+00
(6 rows)

quise borrar ese registro asi

template0=# delete from pg_database where datvacuumxid=553;
delete from pg_database where datvacuumxid=553;
DELETE 0

pero no lo borra!!
no se como arreglar esto, estoy por hacer una miograciosn de datos via script porque conectarme y ver los datos lo puedo hacer .....

gracias de antemano

saludos