Re: Setting a table to be ignored by autovacuum

On 18 Feb 2010, at 18:47, Chris Barnes wrote:

> Right you are, I'm due to upgrade end of month on this system.
> Here I was thinking 8.4. Sorry for the spam.
>
> Chris
>
>
> [postgres(at)pgprd01:~/pgcheck]$ psql
> Welcome to psql 8.3.3, the PostgreSQL interactive terminal.
> Type: \copyright for distribution terms
> \h for help with SQL commands
> \? for help with psql commands
> \g or terminate with semicolon to execute query
> \q to quit
> postgres=#

Actually that just tells that you're using an 8.3 _client_. It doesn't tell what server-version you're using.
For the server version do:

deploy=# SELECT version();
version
----------------------------------------------------------------------------------------------------------------------------------------
PostgreSQL 8.4.1 on i386-apple-darwin10.0.0, compiled by GCC i686-apple-darwin10-gcc-4.2.1 (GCC) 4.2.1 (Apple Inc. build 5646), 64-bit
(1 row)

Alban Hertroys

--
Screwing up is the best way to attach something to the ceiling.

!DSPAM:737,4b7e74ef10441772699480!