Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29])
	by malur.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1TQ83l-0003mW-3k
	for pgsql-admin@postgresql.org; Mon, 22 Oct 2012 02:48:09 +0000
Received: from mail-pb0-f46.google.com ([209.85.160.46])
	by magus.postgresql.org with esmtp (Exim 4.72)
	(envelope-from <ringerc@ringerc.id.au>) id 1TQ83f-00008L-H2
	for pgsql-admin@postgresql.org; Mon, 22 Oct 2012 02:48:08 +0000
Received: by mail-pb0-f46.google.com with SMTP id rr4so1651669pbb.19
	for <pgsql-admin@postgresql.org>; Sun, 21 Oct 2012 19:47:59 -0700 (PDT)
X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed;
	d=google.com; s=20120113;
	h=message-id:date:from:user-agent:mime-version:to:cc:subject
	:references:in-reply-to:x-enigmail-version:content-type
	:content-transfer-encoding:x-gm-message-state;
	bh=AFSAJsIyePU/VI9/RgE/qxuIShsEGkN9JwbLZH0FE9Q=;
	b=bpzFkCzc7+exHrJZaM0lKewOymCfw8xo4IT7Bp9BmgUtGIOZIkxmY4G/qF0MNjVpjX
	cSb7MQujvlWU41WwbRd6XUOWkkFzfIF3gJHTaOHpg0yt1QYGDYT4u+UVpDIIj5Xf0hem
	jyPMI0sEZdsa5UTkDpjSwfbIeg+hnzeoCdyxYHYEY19I2puTke5ERPz8lFcQha73UpSC
	rgsYpjJSfBgmm9aIcGu9vwWr0n7KLLjCBmL3puWMaYsiRThipldmrj5MR3CPR27I6F5D
	URQaj1LWhqgZUrghY7JIH+a+k/t8APJwRTrkhcB5mInxJgoroX5YcM+vYWa5jAY/56g8
	fsig==
Received: by 10.68.197.9 with SMTP id iq9mr25655002pbc.130.1350874079434;
	Sun, 21 Oct 2012 19:47:59 -0700 (PDT)
Received: from ayaki.localdomain (office1.postnewspapers.com.au.
	[150.101.171.128])
	by mx.google.com with ESMTPS id k4sm5116190pax.7.2012.10.21.19.47.56
	(version=SSLv3 cipher=OTHER); Sun, 21 Oct 2012 19:47:58 -0700 (PDT)
Message-ID: <5084B3DA.1080904@ringerc.id.au>
Date: Mon, 22 Oct 2012 10:47:54 +0800
From: Craig Ringer <ringerc@ringerc.id.au>
User-Agent: Mozilla/5.0 (X11; Linux x86_64;
	rv:16.0) Gecko/20121016 Thunderbird/16.0.1
MIME-Version: 1.0
To: teyking2003 <tchongking@hotmail.com>
CC: pgsql-admin@postgresql.org
Subject: Re: Database in psql
References: <1350547390079-5728767.post@n5.nabble.com>
	<CAOR=d=3-T9uxhJjP82VQySVJbAgzZm=sCZei3u8a7p29Jv6p4g@mail.gmail.com>
	<1350692327321-5729131.post@n5.nabble.com>
In-Reply-To: <1350692327321-5729131.post@n5.nabble.com>
X-Enigmail-Version: 1.4.5
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 7bit
X-Gm-Message-State: 
 ALoCoQm79cUUfZTYnZbYJWoEODqlu/SXe/wwrbeE08y2PNTWOlDirVdm6kGkwgVi1KEIi9vnheMr
X-Pg-Spam-Score: -1.9 (-)
X-Archive-Number: 201210/104
X-Sequence-Number: 40220

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