Re: Accessing an old database from a new OS installation. - Mailing list pgsql-general

From Doug McNaught
Subject Re: Accessing an old database from a new OS installation.
Date
Msg-id 87r76td2h0.fsf@asmodeus.mcnaught.org
Whole thread Raw
In response to Re: Accessing an old database from a new OS installation.  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
List pgsql-general
"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
>> 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.

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

pgsql-general by date:

Previous
From: Oleg Bartunov
Date:
Subject: Re: TSearch2 / German compound words / UTF-8
Next
From: Teodor Sigaev
Date:
Subject: Re: TSearch2 / German compound words / UTF-8