| From: | Doug McNaught <doug(at)mcnaught(dot)org> |
|---|---|
| To: | "A(dot) Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)com> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Accessing an old database from a new OS installation. |
| Date: | 2006-01-27 17:07:07 |
| Message-ID: | 87r76td2h0.fsf@asmodeus.mcnaught.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
"A. Kretschmer" <andreas(dot)kretschmer(at)schollglas(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Teodor Sigaev | 2006-01-27 17:17:27 | Re: TSearch2 / German compound words / UTF-8 |
| Previous Message | Oleg Bartunov | 2006-01-27 17:00:44 | Re: TSearch2 / German compound words / UTF-8 |