Re: Upgrading from 7.1.3 to 7.2.3 - Mailing list pgsql-general

On Sun, Nov 10, 2002 at 02:59:58PM -0800, Aurangzeb M. Agha wrote:
>
> BTW, the first thing I did was make two copies of DB/data.

While you were shut down, right?  Because if not, your copies may be
useless.



>
>     Thx Again,
>     Aurangzeb
>
> On Mon, 11 Nov 2002, Justin Clift wrote:
>
> :Hi Aurangzeb,
> :
> :First and *most important question*... have you backed up your data?  Do
> :so *first*.  :)
> :
> :>From everything you've said here, the safest approach will probably be
> :to extract all of your data with the 'pg_dumpall' command, get 7.2.3
> :installed, then reload your data.
> :
> :If this sounds alright to you, then try this:
> :
> :1) Make sure that your old version of PostgreSQL is running
> :
> :2) Extract/dump your data to a file
> :
> :$ pg_dumpall > somefile
> :
> :3) Uninstall your old version of PostgreSQL (version 7.1.3 in your case)
> :
> :4) Delete the old database storage files, you don't need them any more
> :
> :5) Install the new version of PostgreSQL (version 7.2.3 in this case)
> :
> :6) Initialise a new database storage area:
> :
> :$ PGDATA=/some/empty/directory/location
> :$ export PGDATA
> :$ initdb
> :
> :7) Start the new version of PostgreSQL to check it works.  It should
> :startup fine.
> :
> :8) Load your data base into the database
> :
> :$ psql template1 < somefile
> :
> :If that all worked, you should now configure PostgreSQL 7.2.3's memory
> :usage (the defaults are extremely sad for most cases).
> :
> :9) Shut down PostgreSQL
> :
> :10) Edit the postgresql.conf file in the database storage area.  Bruce
> :Momjian's guide gives a good overview of the parameters needed to
> :change:
> :
> :http://www.ca.postgresql.org/docs/momjian/hw_performance/
> :
> :11) Start PostgreSQL again.
> :
> :>From here on, all should be fine.
> :
> :Well, this is the overview of the process, but hopefully it gives you'll
> :be able to figure out the exact commands needed for each one, etc.
> :
> :And just to re-inforce the point... please backup your data before doing
> :this.
> :
> ::-)
> :
> :Regards and best wishes,
> :
> :Justin Clift
> :
> :
> :"Aurangzeb M. Agha" wrote:
> :>
> :> I'm having a horrible time trying to upgrade from 7.1.3 on our Linux RH
> :> 7.2 box to the latest version.
> :>
> :> I first tried "up2date", which failed as it didn't even know there was ANY
> :> update available for Postgres.
> :>
> :> I then downloaded the new TAR for 7.2.3 and walked through the upgrade
> :> steps in pg_upgrade.1, only to be brought to a screaching halt in step 2
> :> of the upgrade:
> :>
> :>         $ pg_upgrade -2
> :>         pg_upgrade is for PostgreSQL version 7.2
> :>         but /usr/local/G101/CMS/App/DB/PG_VERSION contains 7.1.
> :>         Did you run initdb for version 7.1 by mistake?
> :>
> :> When I found the NEW PgSQL bin, I re-ran initdb.  However, running
> :> 'pg_upgrade -2' gave me:
> :>
> :>         Unable to find pg_resetxlog in your path.
> :>         Install it from pgsql/contrib/pg_resetxlog and continue.  Exiting.
> :>
> :> I put pgsql/contrib/pg_resetxlog in the new PgSQL bin
> :> (/usr/local/pgsql/bin) but when I try to run pg_upgrade -2, I get:
> :>
> :>         Locales do not match between the two versions.  Exiting.
> :>
> :> What does that mean?  What do I do to get around it?
> :>
> :> The (old) RPM's I have on my system are:
> :>
> :>         $ rpm -qa | grep -i postgres
> :>         postgresql-contrib-7.1.3-2
> :>         postgresql-tk-7.1.3-2
> :>         postgresql-libs-7.1.3-2
> :>         postgresql-server-7.1.3-2
> :>         postgresql-docs-7.1.3-2
> :>         postgresql-tcl-7.1.3-2
> :>         postgresql-7.1.3-2
> :>         postgresql-jdbc-7.1.3-2
> :>
> :> I'm ready to do the upgrade anyway possible, using pg_upgrade, not using
> :> it, whatever.
> :>
> :> If I do a new install, do I need to remove all the RPM installation I
> :> already have on my machine?  What about everything that got installed
> :> during the upgrade process?
> :>
> :> Any help would be appreciated.
> :>
> :>         Thanks in Advance,
> :>         Aurangzeb
> :>
> :> ---------------------------(end of broadcast)---------------------------
> :> TIP 6: Have you searched our list archives?
> :>
> :> http://archives.postgresql.org
> :
> :
>
> --
> Aurangzeb M. Agha    | Email : aagha@bigfoot.com
>                      | Home  : +3 010 8959.558
> 34 Nafsika St.       | Direct: +3 010 8995.875
> Voula 16673          | Mobile: TBD
> Greece               | Voice : 415 412 4234 (US Only)
>                      | e-Fax : 978 246.0770
> PGP ID: 0x68B3A763   |
>
> "Those who would give up essential liberty to purchase a little
>  temporary safety deserve neither liberty nor safety."
>
>                     - Benjamin Franklin
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110