ayuda

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

Browse pgsql-es-ayuda by date

  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