Problem setting custom auto-vaccum settings - Mailing list pgadmin-support

From Benjamin Krajmalnik
Subject Problem setting custom auto-vaccum settings
Date
Msg-id BF337097BDD9D849A2F4B818DDB2798702947A@stash.stackdump.local
Whole thread Raw
Responses Re: Problem setting custom auto-vaccum settings
List pgadmin-support
I hae a set of tables which are quite large and which only have records
inserted into them.
The size of the tables (which are partitioned tables) reach 2-3GB (data
only) plus indices.

I decided to exclude them from the auto-vacuum process, since I
identified that I was having performance issues when these were being
autovacuumed.

I went to the vacuum settings tabs, clicked on the "Custom Settings"
checkbox, and unchecked the enabled checkbox.
So far so good.  Pressed OK, no error.

Now, if I try to make a change, I am getting the following error:

Column "base_scale_factor" of relation "pg_autovacuum" does not exist.

I am running pgAdmin 1.4.2 against PostgreSQL 8.1.4, both on Windows.


pgadmin-support by date:

Previous
From: Dave Page
Date:
Subject: Re: Scheduling a backup job (was: pgAdmin III
Next
From: "Dave Page"
Date:
Subject: Re: Problem setting custom auto-vaccum settings