Skip site navigation (1) Skip section navigation (2)

BUG #2241: "vacuumdb -a" remove freeze

From: "Olleg Samoylov" <olleg(at)mipt(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #2241: "vacuumdb -a" remove freeze
Date: 2006-02-06 14:58:50
Message-ID: 20060206145850.6CE8BF0AC7@svr2.postgresql.org (view raw or flat)
Thread:
Lists: pgsql-bugs
The following bug has been logged online:

Bug reference:      2241
Logged by:          Olleg Samoylov
Email address:      olleg(at)mipt(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 datname,datvacuumxid,datfrozenxid from pg_database where
datname='template1';
  datname  | datvacuumxid | datfrozenxid 
-----------+--------------+--------------
 template1 |         2000 |   3221227473
(1 row)
template1=# vacuum freeze;
VACUUM
template1=# select datname,datvacuumxid,datfrozenxid from pg_database where
datname='template1';
  datname  | datvacuumxid | datfrozenxid 
-----------+--------------+--------------
 template1 |         2056 |         2056
(1 row)

Okey, frozen, now lanch vacuumdb from command line:

# vacuumdb --version
vacuumdb (PostgreSQL) 8.1.0
# vacuumdb -a -U postgres
vacuumdb: vacuuming database "postgres"
VACUUM
vacuumdb: vacuuming database "template1"
VACUUM

Oops, template1 must not be vacuumed.

template1=# select datname,datvacuumxid,datfrozenxid from pg_database where
datname='template1';
  datname  | datvacuumxid | datfrozenxid 
-----------+--------------+--------------
 template1 |         2171 |   3221227644
(1 row)

template1 is unfrozen.

pgsql-bugs by date

Next:From: Tom LaneDate: 2006-02-06 18:10:42
Subject: Re: BUG #2239: "vacuumdb -a" remove freeze
Previous:From: Andreas ErberDate: 2006-02-06 14:41:39
Subject: BUG #2240: length() with geometric types

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group