Re: postgres7.2.1 upgrading - Mailing list pgsql-sql

From Christopher Kings-Lynne
Subject Re: postgres7.2.1 upgrading
Date
Msg-id GNELIHDDFBOCMGBFGEFOOEOPCCAA.chriskl@familyhealth.com.au
Whole thread Raw
In response to postgres7.2.1 upgrading  (Jie Liang <jie@stbernard.com>)
List pgsql-sql
> http://www.ca.postgresql.org/sitess.html
> says that:
> The current version of PostgreSQL is 7.2.1.
> NOTE: An initdb will only be required if upgrading from pre 7.2
>
> So, if my current version is 7.2.0 and I want upgrade it to
> 7.2.1, what file should I download in order to get 'intidb'?
> if only the 'initdb' is required,
> then what is the upgrade procedure?
> I don't need to install whole 7.2.1 at all, do I.
> my guess is that:
> 1.shutdown the db;
> 2.copy initdb of 7.2.1 to the location of initdb of 7.2.0;
> 3.re_intialize db by running initdb;
> 4.re_start postmaster.

You do not need to do anything special.  Just install the new version of
postgres over your existing version (making a backup dump of your data
first, of course).  7.2.0 is the same as 7.2, it's not 'pre 7.2'.

Chris





pgsql-sql by date:

Previous
From: Rudi Starcevic
Date:
Subject: Re: Selecting data from a table created in another database...
Next
From: Mark Frazer
Date:
Subject: Re: Possible Bug regarding temp tables (sql or psql?)