Re: UPGRADING 7.1 TO 7.3.4 - Mailing list pgsql-general

From Jan Wieck
Subject Re: UPGRADING 7.1 TO 7.3.4
Date
Msg-id 3FB6A231.6000507@Yahoo.com
Whole thread Raw
In response to Re: UPGRADING 7.1 TO 7.3.4  ("Joshua D. Drake" <jd@commandprompt.com>)
List pgsql-general
Joshua D. Drake wrote:

> No.
> You need to remove 7.3.4 (make sure you backup your data directory)
> Install 7.1.3 from source.
> Run pg_dumpall
> Backup your data directory
> Move your data directory
> Remove 7.1.3
> Install 7.3.4
> Restore from the pg_dump you did.

I would rather recommend not deinstalling 7.3.4!

You can compile and install 7.1.3 into a temporary directory and
listening to a different port.

     ./configure --prefix=/usr/local/pg71_temp --with-pgport=5439
     make
     make install

Now you restore the old installations data directory into the directory
/usr/local/pg71_temp/data and start the 7.1.3 postmaster.

You now use the 7.3.4 pg_dumpall command to dump the contents

     PGPORT=5439
     export PGPORT
     pg_dumpall >(wherever_you_want_the_dumpfile)

You can stop the 7.1.3 postmaster now and proceed with reloading the
dump into your 7.3.4 installation

     unset PGPORT
     psql <(that_darn_dumpfile)


Jan

>
> Sincerely,
>
> Joshua Drake
>
>
> Piyush Agarwal wrote:
>
>>Hi,
>>I had the version 7.1 of postgresql running fine on Redhat 7.1.
>>Before upgrading my OS to RedHat 9, I forgot saying pgdump_all
>>- is there a way now to read the files stored with version 7.1
>>by using 7.3.4 without having to uninstall 7.3.4 and reinstall
>>7.1 just to say this command ?
>>
>>Thanx in advance for any help.
>>
>>piyush.
>>
>>
>>---------------------------(end of broadcast)---------------------------
>>TIP 6: Have you searched our list archives?
>>
>>               http://archives.postgresql.org
>>
>>
>


--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me.                                  #
#================================================== JanWieck@Yahoo.com #


pgsql-general by date:

Previous
From: David Wheeler
Date:
Subject: Re: GUIDs
Next
From: Doug McNaught
Date:
Subject: Re: GUIDs