Re: UPGRADING 7.1 TO 7.3.4

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(at)Yahoo(dot)com #