pg.ddx.io  pgsql-admin@postgresql.org mailing list archive  
help / color / mirror / Atom feed
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




view thread (7+ messages)  latest in thread

Message-ID: <5084B3DA.1080904@ringerc.id.au>
Permalink:  ../5084B3DA.1080904@ringerc.id.au/
Also on:    postgresql.org/message-id/5084B3DA.1080904@ringerc.id.au

 · 

reply

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