From: Scott Marlowe <scott.marlowe@gmail.com>
To: olivier.boissard@cerene.fr <olivier.boissard@cerene.fr>
Cc: Guillaume Lelarge <guillaume@lelarge.info>
Cc: pgsql-admin@postgresql.org
Subject: Re: How to uses self query plan
Date: Wed, 19 Dec 2007 17:25:03 -0600
Message-ID: <dcc563d10712191525m30bf8363o6558ec19072f5921@mail.gmail.com> (raw)
In-Reply-To: <4769A698.9070700@cerene.fr>
References: <476847DB.9090401@cerene.fr>
<dcc563d10712181446t2bc5dc0ftaaf0f6798be7f08c@mail.gmail.com>
<4768CEEF.9060506@cerene.fr>
<dcc563d10712190733n12af01f6tc9ef225e278a04ed@mail.gmail.com>
<476999FC.9090306@cerene.fr>
<47699CBB.7080607@lelarge.info>
<4769A698.9070700@cerene.fr>
On Dec 19, 2007 5:17 PM, olivier.boissard@cerene.fr
<olivier.boissard@cerene.fr> wrote:
> Guillaume Lelarge a écrit :
> > olivier.boissard@cerene.fr wrote:
> >
> >> You're right .
> >> I will begin by migrate postgresql version.
> >> postgresql is now to 8.3 version . A lot of performance inprovements
> >> have been made in this last version .
> >> In any case I must do a pg_dump/pg_restore.
> >> So , Should I try directly 8.3 version or is it more cautious to stay in
> >> 8.1.x version ?
> >>
> >>
> >
> > It mostly depends on you. PostgreSQL 8.3 is still in beta phase. So, if
> > you're also on development stage, you can use 8.3. Otherwise, it's
> > better to use the latest stable available, which means 8.2.5.
> >
> >
> >
> I want in fact to make test on a server before , when validated migrate
> on production server , so 8.2.5 is more appropriate.
> Will I be able to keep my postgresql.conf file or is it not compatible ?
No, you'll need to edit the new one by hand to reflect the changes
you've made in the old one. Some things get renamed from one to the
next, and often newer versions of pgsql have new settings you that the
old version's postgresql.conf wouldn't know about.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-admin@postgresql.org
Cc: scott.marlowe@gmail.com, olivier.boissard@cerene.fr, guillaume@lelarge.info
Subject: Re: How to uses self query plan
In-Reply-To: <dcc563d10712191525m30bf8363o6558ec19072f5921@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox