From: | Chris Barnes <compuguruchrisbarnes(at)hotmail(dot)com> |
---|---|
To: | <dalroi(at)solfertje(dot)student(dot)utwente(dot)nl> |
Cc: | <schmiddy(at)gmail(dot)com>, <dev(at)archonet(dot)com>, Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: Setting a table to be ignored by autovacuum |
Date: | 2010-02-19 14:03:01 |
Message-ID: | BLU149-W15F1F98AE15EE5F6423AEBD4460@phx.gbl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
It is...
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=# SELECT version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 8.3.3 on x86_64-unknown-linux-gnu, compiled by GCC gcc (GCC) 3.4.6 20060404 (Red Hat 3.4.6-9)
(1 row)
postgres=#
> Subject: Re: [GENERAL] Setting a table to be ignored by autovacuum
> From: dalroi(at)solfertje(dot)student(dot)utwente(dot)nl
> Date: Fri, 19 Feb 2010 12:24:24 +0100
> CC: schmiddy(at)gmail(dot)com; dev(at)archonet(dot)com; pgsql-general(at)postgresql(dot)org
> To: compuguruchrisbarnes(at)hotmail(dot)com
>
> 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:1029,4b7e74ee10441497119330!
>
>
_________________________________________________________________
Check your Hotmail from your phone.
http://go.microsoft.com/?linkid=9708121
From | Date | Subject | |
---|---|---|---|
Next Message | Raymond O'Donnell | 2010-02-19 17:55:22 | Re: PostgreSQL fails to start |
Previous Message | Alvaro Herrera | 2010-02-19 13:47:55 | Re: Doubts about oid |