Accessing an old database from a new OS installation.
Dear all,
I am a novice user, so any help with the following problem
would be greatly appreciated.
I had Suse 9.1 installed on one hard disk in my machine
(/dev/hda). On this machine Postgresql 7.4 was installed
and I had one database which, I believe, was installed
in the default location
This hard disk no longer boots and so I have
installed Suse 10.0 on another hard disk in the same
machine (/dev/hdb). This OS has Postgresql 8.1 installed
and I would like to be able to connect to the database on
the old hard disk (/dev/hda) so that I can dump it to
make a backup and eventually transfer it to the new hard disk.
How should I go about doing this? Are there any problems
I should be aware of in moving from version 7.4 to 8.1?
thanks,
Matthew Henderson
Am Freitag, 27. Januar 2006 11:30 schrieb Matthew Henderson:
How should I go about doing this? Are there any problems
I should be aware of in moving from version 7.4 to 8.1?
For one thing you won't be able to read the 7.4 database using 8.1 binaries,
so you need to get 7.4 installed first in order to make a dump. If there are
no packages available you will have to compile it by hand.
--
Peter Eisentraut
http://developer.postgresql.org/~petere/
Okay, so if I have 7.4 installed and I have the old
harddisk mount under /mnt/hda can I do something
like
pg_dump /mnt/hda/path_to_old_database > dump.txt
???
Show quoted text
On Fri, Jan 27, 2006 at 02:47:21PM +0100, Peter Eisentraut wrote:
Am Freitag, 27. Januar 2006 11:30 schrieb Matthew Henderson:
How should I go about doing this? Are there any problems
I should be aware of in moving from version 7.4 to 8.1?For one thing you won't be able to read the 7.4 database using 8.1 binaries,
so you need to get 7.4 installed first in order to make a dump. If there are
no packages available you will have to compile it by hand.--
Peter Eisentraut
http://developer.postgresql.org/~petere/
am 27.01.2006, um 14:21:31 +0000 mailte Matthew Henderson folgendes:
Okay, so if I have 7.4 installed and I have the old
harddisk mount under /mnt/hda can I do something
likepg_dump /mnt/hda/path_to_old_database > dump.txt
No, this is imposible IMHO. You need a PG-Server with this version
(7.4), to read the data. pg_dump is only a client for the DB, it can't
read the files.
HTH, Andreas
--
Andreas Kretschmer (Kontakt: siehe Header)
Heynitz: 035242/47215, D1: 0160/7141639
GnuPG-ID 0x3FFF606C http://wwwkeys.de.pgp.net
=== Schollglas Unternehmensgruppe ===
"A. Kretschmer" <andreas.kretschmer@schollglas.com> writes:
am 27.01.2006, um 14:21:31 +0000 mailte Matthew Henderson folgendes:
Okay, so if I have 7.4 installed and I have the old
harddisk mount under /mnt/hda can I do something
likepg_dump /mnt/hda/path_to_old_database > dump.txt
No, this is imposible IMHO. You need a PG-Server with this version
(7.4), to read the data. pg_dump is only a client for the DB, it can't
read the files.
In addition, it's considered best practice to run (in this case) the
7.4 server against the old database, and use the 8.X pg_dump to dump
it out for loading into the 8.X server.
-Doug