Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org, Andreas Laggner <andreas(dot)laggner(at)vti(dot)bund(dot)de>
Subject: Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n
Date: 2010-11-19 22:45:33
Message-ID: 17681.1290206733@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Adrian Klaver <adrian(dot)klaver(at)gmail(dot)com> writes:
> Now I understand. I wonder if this would be a good time to ask about
> whether pg_restore could be made to work with plain-text files:)

Not in any particularly useful way --- the plain text dump wouldn't
really support selective restore, etc etc.

> ... Though I could see a shortcut that passes a plain text file to
> psql or at least creates an error message that says:

> "Please use psql with the -f option to restore this file"

Yeah, I was thinking a hint might be the most useful fix too.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Joshua D. Drake 2010-11-19 22:55:50 Re: Upgrading 8.2 to 8.4: pg_restore: did not find magic string in file header\n
Previous Message Andy Colson 2010-11-19 22:14:50 Re: Best practice to get performance