From: | Gourish Singbal <gourish(at)gmail(dot)com> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Subject: | Fwd: vacuuming template0 gave ERROR |
Date: | 2005-12-26 12:32:44 |
Message-ID: | 674d1f8a0512260432g56e53734h1583e36b72faeec3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin pgsql-performance |
---------- Forwarded message ----------
From: Gourish Singbal <gourish(at)gmail(dot)com>
Date: Dec 26, 2005 5:04 PM
Subject: vacuuming template0 gave ERROR
To: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Guys,
Got the following ERROR when i was vacuuming the template0 database.
postgresql server version is 7.4.5 and stats info in postgresql.conf is
# - Query/Index Statistics Collector -
stats_start_collector = true
stats_command_string = true
stats_block_level = true
stats_row_level = tue
#stats_reset_on_server_start = true
============================
step 1
update pg_database set datallowconn=TRUE where datname='template0';
step 2
\c template0
vacuum analyze verbose
......
.....
INFO: vacuuming "pg_catalog.pg_statistic"
ERROR: could not access status of transaction 1107341112
DETAIL: could not open file "/home/postgres/data/pg_clog/0420": No such
file or directory
step 3
postgres(at)test1:~> /usr/local/pgsql/bin/psql database1 -c 'SELECT datname,
age(datfrozenxid) FROM pg_database';
datname | age
-----------+------------
template0 | 1112108248
database1 | 1074511487
template1 | 1073987669
(3 rows)
Files in the pg_clog are:-
postgres(at)test1:~/data/pg_clog> ls -lart
total 417
-rw------- 1 postgres postgres 262144 2005-12-26 02:09 0443
drwx------ 2 postgres postgres 96 2005-12-26 02:17 ./
drwx------ 6 postgres postgres 640 2005-12-26 03:22 ../
-rw------- 1 postgres postgres 163840 2005-12-26 03:23 0444
Problem: template0 is not getting vacuumed due to the above ERROR.. please
let me know whats the solution.
--
Best,
Gourish Singbal
--
Best,
Gourish Singbal
From | Date | Subject | |
---|---|---|---|
Next Message | Alain Rodriguez Arias | 2005-12-26 14:16:13 | Re: lo_ functions |
Previous Message | Gourish Singbal | 2005-12-26 11:34:28 | vacuuming template0 gave ERROR |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2005-12-26 16:02:52 | Re: vacuuming template0 gave ERROR |
Previous Message | Luke Lonergan | 2005-12-26 12:13:22 | Re: What's the best hardver for PostgreSQL 8.1? |