Re: postgres7.2.1 upgrading

From: "Christopher Kings-Lynne" <chriskl(at)familyhealth(dot)com(dot)au>
To: "Jie Liang" <jie(at)stbernard(dot)com>
Cc: <pgsql-sql(at)postgresql(dot)org>
Subject: Re: postgres7.2.1 upgrading
Date: 2002-07-04 02:55:18
Message-ID: GNELIHDDFBOCMGBFGEFOOEOPCCAA.chriskl@familyhealth.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Bruce Momjian 2002-07-04 03:03:13 Re: [SQL] pg_restore cannot restore function
Previous Message Rudi Starcevic 2002-07-04 01:47:58 Re: Selecting data from a table created in another database...