From: | "Diego Barreto" <diegob(at)allytech(dot)com> |
---|---|
To: | <pgsql-es-ayuda(at)postgresql(dot)org> |
Subject: | ayuda |
Date: | 2007-08-02 14:56:56 |
Message-ID: | 072C784B062E6A43B3A0B6A38F31CBEA068945@allytechnt.allytech.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-es-ayuda |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Agustin Ignacio Genoves | 2007-08-02 14:58:54 | Funciones de usuario |
Previous Message | Espartano | 2007-08-02 13:37:02 | Re: perfomance de postgres sobre LVM de Linux |