Re: Database in psql - Mailing list pgsql-admin

From Craig Ringer
Subject Re: Database in psql
Date
Msg-id 5084B3DA.1080904@ringerc.id.au
Whole thread Raw
In response to Re: Database in psql  (teyking2003 <tchongking@hotmail.com>)
Responses Re: Database in psql  (teyking2003 <tchongking@hotmail.com>)
List pgsql-admin
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


pgsql-admin by date:

Previous
From: teyking2003
Date:
Subject: Re: Database in psql
Next
From: Craig Ringer
Date:
Subject: Re: [GENERAL] Streaming Replication Server Crash