By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,710 Members | 1,887 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,710 IT Pros & Developers. It's quick & easy.

UPGRADING 7.1 TO 7.3.4

P: n/a
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

Nov 12 '05 #1
Share this Question
Share on Google+
2 Replies


P: n/a
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

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

Nov 12 '05 #2

P: n/a
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

Nov 12 '05 #3

This discussion thread is closed

Replies have been disabled for this discussion.