X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id 0DB729DDD32 for ; Mon, 26 Dec 2005 07:34:29 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 29606-07 for ; Mon, 26 Dec 2005 06:34:31 -0400 (AST) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from zproxy.gmail.com (zproxy.gmail.com [64.233.162.204]) by postgresql.org (Postfix) with ESMTP id 7C4259DDD31 for ; Mon, 26 Dec 2005 07:34:26 -0400 (AST) Received: by zproxy.gmail.com with SMTP id 13so1164439nzn for ; Mon, 26 Dec 2005 03:34:29 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=NWV2rM5tcgk8gCvTE+Eo6PW6BDJd13ROz2TYWVSV2eA+jGKO6OqP+QtClA2GzuhaW3QtlofyL33kWtltYR7eCLgj/L6OVecSdrA0bwbpnnRz64QmZzeDycgoEAVfqtw7Lt6swatiOXqGKBq/azB4qSj8yfkTkYW0tTcFk52kdLM= Received: by 10.36.148.14 with SMTP id v14mr3171877nzd; Mon, 26 Dec 2005 03:34:28 -0800 (PST) Received: by 10.36.72.7 with HTTP; Mon, 26 Dec 2005 03:34:28 -0800 (PST) Message-ID: <674d1f8a0512260334g3b72c635m7d46ab457a8f2694@mail.gmail.com> Date: Mon, 26 Dec 2005 17:04:28 +0530 From: Gourish Singbal To: "pgsql-admin@postgresql.org" Subject: vacuuming template0 gave ERROR MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1121_24088814.1135596868818" X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.186 required=5 tests=[AWL=0.185, HTML_MESSAGE=0.001] X-Spam-Score: 0.186 X-Spam-Level: X-Archive-Number: 200512/308 X-Sequence-Number: 20028 ------=_Part_1121_24088814.1135596868818 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline 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 =3D true stats_command_string =3D true stats_block_level =3D true stats_row_level =3D tue #stats_reset_on_server_start =3D true =3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D step 1 update pg_database set datallowconn=3DTRUE where datname=3D'template0'; step 2 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@test1:~> /usr/local/pgsql/bin/psql ecommerce -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@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 ------=_Part_1121_24088814.1135596868818 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline
 
Guys,
 
Got the following ERROR when i was vacuuming the template0 database. <= /div>
postgresql server version is 7.4.5 and stats info in postgresql.conf i= s

# - Query/Index Statistics Collector -

stats_start_collector =3D true
stats_command_string =3D true
stats= _block_level =3D true
stats_row_level =3D tue
#stats_reset_on_server_= start =3D true

=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D= =3D=3D=3D=3D

step 1

update pg_database set datallowconn=3DTRUE where datname=3D'template0';<= /p>

 
step 2
vacuum analyze verbose
......
.....
INFO:  vacuuming "pg_catalog.pg_statistic"
ERROR:&nb= sp; could not access status of transaction 1107341112
DETAIL:  coul= d not open file "/home/postgres/data/pg_clog/0420": No such file = or directory
 
step 3
postgres@test1:~> /usr/local/= pgsql/bin/psql ecommerce -c 'SELECT datname, age(datfrozenxid) FROM pg_data= base';
  datname  |    age
-----------+-----= -------
 template0 | 1112108248
 database1 | 1074511487
 template1 | 1073987669
(3 rows= )
 
Files in the pg_clog are:-
postgres@test1:~/data= /pg_clog> ls -lart
total 417
-rw-------  1 postgres postg= res 262144 2005-12-26 02:09 0443
drwx------  2 postgres postgres&nb= sp;    96 2005-12-26 02:17 ./
drwx------  6 postgres postgres    640 2005-12-26 0= 3:22 ../
-rw-------  1 postgres postgres 163840 2005-12-26 03:23 04= 44
 
Problem: template0 is not getting vacuumed due to the above ERROR.. pl= ease let me know whats the solution.
--
Best,
Gourish Singbal ------=_Part_1121_24088814.1135596868818--