PostgreSQL Discussion - Accessing an old database from a new OS installation.

Author

Accessing an old database from a new OS installation.

Matthew Henderson

2006-01-27, 7:23 am

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

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

Peter Eisentraut

2006-01-27, 9:23 am

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/

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

Matthew Henderson

2006-01-27, 9:23 am

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

???

On Fri, Jan 27, 2006 at 02:47:21PM +0100, Peter Eisentraut wrote:
> Am Freitag, 27. Januar 2006 11:30 schrieb Matthew Henderson:
>
> 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/

---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

A. Kretschmer

2006-01-27, 9:23 am

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
> like
>
> pg_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 ===

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

Doug McNaught

2006-01-27, 11:23 am

"A. Kretschmer" <andreas. kretschmer@schollgla
s.com> writes:

> am 27.01.2006, um 14:21:31 +0000 mailte Matthew Henderson folgendes:
>
> 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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Sponsored Links