RE: ayuda

me permite hacer vacuum si pongo todas las conexiones a false

[postgres(at)proxy2allytechcom data]$ psql -e template0
psql: FATAL: database "template0" is not currently accepting connections
[postgres(at)proxy2allytechcom data]$ psql -e template1
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template1=# UPDATE pg_database SET datallowconn = true;
UPDATE pg_database SET datallowconn = true;
UPDATE 5
template1=# \q
[postgres(at)proxy2allytechcom data]$ psql -e template0
Welcome to psql 8.0.1, the PostgreSQL interactive terminal.

Type: \copyright for distribution terms
\h for help with SQL commands
\? for help with psql commands
\g or terminate with semicolon to execute query
\q to quit

template0=# TRUNCATE pg_statistic;
TRUNCATE pg_statistic;
ERROR: permission denied: "pg_statistic" is a system catalog
template0=# VACUUM FREEZE;
VACUUM FREEZE;
WARNING: some databases have not been vacuumed in 1949927586 transactions
HINT: Better vacuum them within 197556061 transactions, or you may have a wraparound failure.
VACUUM
template0=# VACUUM;
VACUUM;
WARNING: some databases have not been vacuumed in 1949927638 transactions
HINT: Better vacuum them within 197556009 transactions, or you may have a wraparound failure.
VACUUM
template0=# VACUUM;
VACUUM;
WARNING: some databases have not been vacuumed in 1949927690 transactions
HINT: Better vacuum them within 197555957 transactions, or you may have a wraparound failure.
VACUUM
template0=# VACUUM FULL;
VACUUM FULL;
WARNING: some databases have not been vacuumed in 1949927743 transactions
HINT: Better vacuum them within 197555904 transactions, or you may have a wraparound failure.
VACUUM
template0=# UPDATE pg_database SET datallowconn = false;
UPDATE pg_database SET datallowconn = false;
UPDATE 5
template0=# VACUUM;
VACUUM;
VACUUM
template0=# VACUUM FULL;
VACUUM FULL;
VACUUM
template0=# VACUUM FREEZE;
VACUUM FREEZE;
VACUUM

-----Mensaje original-----
De: Alvaro Herrera [mailto:alvherre(at)commandprompt(dot)com]
Enviado el: Jueves, 02 de Agosto de 2007 06:41 p.m.
Para: Diego Barreto
CC: pgsql-es-ayuda(at)postgresql(dot)org
Asunto: Re: [pgsql-es-ayuda] ayuda

Diego Barreto escribió:

> la salida me da esto
>
> emplate1=# SELECT xmin, xmax, ctid, tableoid, oid, nspname, (SELECT usename FROM pg_catalog.pg_user WHERE usesysid = nspowner) as rolname, nspacl FROM pg_namespace;
> SELECT xmin, xmax, ctid, tableoid, oid, nspname, (SELECT usename FROM pg_catalog.pg_user WHERE usesysid = nspowner) as rolname, nspacl FROM pg_namespace;
> ERROR: more than one row returned by a subquery used as an expression

Oops, sorry, era obvio :-( Prueba esto otro

select xmin, xmax, ctid, oid, usename from pg_authid;

Si te dice que pg_authid no existe entonces cambialo por pg_shadow

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support