Thread: ...

        Tue, 09 Apr 2013 04:23:04 -0700 (PDT)
 Apr 2013 04:23:04 -0700 (PDT)
X-Newsgroups: pgsql.general
Date: Tue, 9 Apr 2013 04:23:03 -0700 (PDT)
In-Reply-To: <47408590-a31c-4541-a2e4-1da06bb7c64b@googlegroups.com>
Complaints-To: groups-abuse@google.com
Injection-Info: glegroupsg2000goo.googlegroups.com; posting-host=210.143.35.31;
 posting-account=GbL1LQoAAAA52LT6cIjZnkdtjTyQZ5G0
References: <47408590-a31c-4541-a2e4-1da06bb7c64b@googlegroups.com>
User-Agent: G2/1.0
MIME-Version: 1.0
Message-ID: <9b699569-26a1-469f-afd0-10ec541f41b9@googlegroups.com>
Subject: Re: Vacuuming time of template1 db
From: hdsarma@gmail.com
Injection-Date: Tue, 09 Apr 2013 11:23:04 +0000
Content-Type: text/plain; charset=ISO-8859-1
To: pgsql-general@postgresql.org

PostgreSQL verison is 8.1

On 4/9/2013 4:23 AM, News Subsystem wrote:
> PostgreSQL verison is 8.1

that version has been out of date for YEARS now.  the last release in
the 8.1 family, 8.1.23, was in 2010.  8.1 was released in 2005.

The oldest version still supported is 8.4, and 9.2 is the latest.

that said, how big is template1?  has someone accidentally put a bunch
of data into it?

      select pg_database_size('template1');

will give the size (I think that worked in 8.1)

--
john r pierce                                      37N 122W
somewhere on the middle of the left coast