From: | "Olleg Samoylov" <olleg_s(at)mail(dot)ru> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | BUG #2239: "vacuumdb -a" remove freeze |
Date: | 2006-02-06 11:50:12 |
Message-ID: | 20060206115012.DEC6BF0AC7@svr2.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 2239
Logged by: Olleg Samoylov
Email address: olleg_s(at)mail(dot)ru
PostgreSQL version: 8.1
Operating system: Linux (debian-amd64)
Description: "vacuumdb -a" remove freeze
Details:
template1=# select version();
version
----------------------------------------------------------------------------
------------------------------------
PostgreSQL 8.1.0 on x86_64-pc-linux-gnu, compiled by GCC cc (GCC) 4.0.3
20051111 (prerelease) (Debian 4.0.2-4)
(1 row)
template1=# select * from pg_database where datname='template1';
datname | datdba | encoding | datistemplate | datallowconn | datconnlimit
| datlastsysoid | datvacuumxid | datfrozenxid | dattablespace | datconfig |
datacl
-----------+--------+----------+---------------+--------------+-------------
-+---------------+--------------+--------------+---------------+-----------+
------------------------
template1 | 10 | 6 | t | t | -1
| 10792 | 1112 | 3221226585 | 1663 | |
{postgres=CT/postgres}
(1 row)
template1=# vacuum freeze;
VACUUM
template1=# select * from pg_database where datname='template1';
datname | datdba | encoding | datistemplate | datallowconn | datconnlimit
| datlastsysoid | datvacuumxid | datfrozenxid | dattablespace | datconfig |
datacl
-----------+--------+----------+---------------+--------------+-------------
-+---------------+--------------+--------------+---------------+-----------+
------------------------
template1 | 10 | 6 | t | t | -1
| 10792 | 1172 | 1172 | 1663 | |
{postgres=CT/postgres}
(1 row)
Okey, freezed, now launch vacuumdb from command line:
# vacuumdb -a -U postgres
vacuumdb: vacuuming database "postgres"
VACUUM
vacuumdb: vacuuming database "template1"
VACUUM
Opps, template1 must not be vacuumed.
select * from pg_database where datname='template1';
datname | datdba | encoding | datistemplate | datallowconn | datconnlimit
| datlastsysoid | datvacuumxid | datfrozenxid | dattablespace | datconfig |
datacl
-----------+--------+----------+---------------+--------------+-------------
-+---------------+--------------+--------------+---------------+-----------+
------------------------
template1 | 10 | 6 | t | t | -1
| 10792 | 1287 | 3221226760 | 1663 | |
{postgres=CT/postgres}
(1 row)
Unfreezed indeed.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter van der Maas | 2006-02-06 12:32:33 | Re: BUG #2182: Internal account lookup failure: |
Previous Message | alexis | 2006-02-05 19:57:56 | Re: BUG #2237: SELECT optimizer drops everything improperly |