From: Craig Ringer <ringerc@ringerc.id.au>
To: teyking2003 <tchongking@hotmail.com>
Cc: pgsql-admin@postgresql.org
Subject: Re: Database in psql
Date: Mon, 22 Oct 2012 10:47:54 +0800
Message-ID: <5084B3DA.1080904@ringerc.id.au> (raw)
In-Reply-To: <1350692327321-5729131.post@n5.nabble.com>
References: <1350547390079-5728767.post@n5.nabble.com>
<CAOR=d=3-T9uxhJjP82VQySVJbAgzZm=sCZei3u8a7p29Jv6p4g@mail.gmail.com>
<1350692327321-5729131.post@n5.nabble.com>
On 10/20/2012 08:18 AM, teyking2003 wrote:
> for the upgrade of psql version, do we need to reconfigure all again?
The manual explains the details:
http://www.postgresql.org/docs/current/static/upgrading.html
You should also read the release notes for the major versions (8.3, 8.4,
9.0, 9.1 and 9.2) between your version and the target for your upgrade.
Read the compatibility notes.
You will need to be particularly careful of:
- The move to standard_conforming_strings
- The change of bytea_format
- The removal of implicit casts to text
- Upgrading contrib modules to extensions
so you will need to do some application testing.
--
Craig Ringer
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: ringerc@ringerc.id.au, tchongking@hotmail.com
Subject: Re: Database in psql
In-Reply-To: <5084B3DA.1080904@ringerc.id.au>
* 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