Обсуждение: UPGRADING 7.1 TO 7.3.4

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.

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.

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
>
>

--
Command Prompt, Inc., home of Mammoth PostgreSQL - S/ODBC and S/JDBC
Postgresql support, programming shared hosting and dedicated hosting.
+1-503-222-2783 - jd@commandprompt.com - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org

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 #