Re: can't stop autovacuum by HUP'ing the server

On Tue, Aug 26, 2008 at 12:21 PM, Alvaro Herrera <alvherre(at)commandprompt(dot)com
> wrote:

> Dave Cramer wrote:
>
> > Ok, back to why
> >
> > turns out template0 is the culprit, why is autovac not vacuuming this ?
>
> Hmm ... template0 is not supposed to need vacuuming, because it is
> frozen ... is it marked with datallowconn=false?

Yes

select * from pg_database where datname='template0';
datname | datdba | encoding | datistemplate | datallowconn | datconnlimit
| datlastsysoid | datfrozenxid | dattablespace | datconfig |
datacl
-----------+--------+----------+---------------+--------------+--------------+---------------+--------------+---------------+-----------+-------------------------------------
template0 | 10 | 6 | t | f | -1
| 11510 | 201850617 | 1663 | |
{=c/postgres,postgres=CTc/postgres}

So how to fix ?

>
>
> --
> Alvaro Herrera
> http://www.CommandPrompt.com/
> PostgreSQL Replication, Consulting, Custom Development, 24x7 support
>