Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Andrus Moor" <eetasoft(at)online(dot)ee>
Cc: adrian(dot)klaver(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org
Subject: Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Date: 2010-12-15 16:25:14
Message-ID: 7138.1292430314@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Andrus Moor" <eetasoft(at)online(dot)ee> writes:
>> No, this is just pilot error. Any version of pg_dump will produce
>> output that is meant to be loaded into the matching server version
>> (or a later version). If you are intending to load back into 8.4,
>> use the 8.4 pg_dump.

> Windows application needs to support backup/restore for all servers >=8
> between same server version.

Why does it have that requirement? And why doesn't it use the pg_dump
that came with the server? It seems pretty lame to assume that your app
has to provide pg_dump and not any other part of the Postgres
installation.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2010-12-15 16:26:16 Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore
Previous Message Andrus Moor 2010-12-15 15:34:34 Re: How to restore from backup to 8.4.3 server using 9.0 dump/restore