Search Postgresql Archives

Re: Setting a table to be ignored by autovacuum

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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: Setting a table to be ignored by autovacuum
> From: dalroi@xxxxxxxxxxxxxxxxxxxxxxxxxxxx
> Date: Fri, 19 Feb 2010 12:24:24 +0100
> CC: schmiddy@xxxxxxxxx; dev@xxxxxxxxxxxx; pgsql-general@xxxxxxxxxxxxxx
> To: compuguruchrisbarnes@xxxxxxxxxxx
>
> 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@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!
>
>


Live connected with Hotmail on your phone. Learn more.

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux