UPGRADING 7.1 TO 7.3.4

[Piyush Agarwal]

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

[Joshua D. Drake]

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.
[phone] - [e-mail] - http://www.commandprompt.com
Editor-N-Chief - PostgreSQl.Org - http://www.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match

[Jan Wieck]

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. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 9: the planner will ignore your desire to choose an index scan if your
joining column's datatypes do not match