Hello Roy et al...
Just following on the pg_restore thing, I tried it with the --format=t
option, and this time the error is:
pg_restore: [archiver] unsupported version (1.7) in file header. I had
also attemped the dump with the -i option to ignore version (?), but the
result is still the same.
Googling around doesn't give me much to work on.
Using the redirection as you describe, it seems to interpret the binary
contents of the tables as text commands and hence scrolls off for some time
with "invalid command", leaving a file with a name of >100 gibberish
characters on the filesystem. I think this may work for dumps containing
To: "'John-Paul Delaney'" <[email protected]
Subject: RE: [NOVICE] pg_ [dump & restore] invalid archive problem
From what I can remember, (anybody feel free to correct me on this if I'm
wrong), pg_restore expects a different format to that output from pg_dump,
Not very logical I know but I was doing a similar thing a while back but it
was a few versions back now. I was confused by the fact pg_restore did not
restore a pg_dump. I am pretty sure that the psql < databasedump is the
to do it.
Did you make sure that the database you were trying to recreate was a brand
new one and owned by the same user as the original?
Maybe you could post a few error lines from the psql < databasedump command
that you ran and I'll see if I recognize anything there.
From: John-Paul Delaney
Sent: 04 November 2004 12:30
To: [email protected]
Subject: Re: [NOVICE] pg_ [dump & restore] invalid archive problem
Unfortunately that parsed the file and output lot's of invalid command
strings with nothing written to the db in the end.
What's the pg_restore command used for then, if not to restore from a
pg_dump, I wonder?
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
This e-mail contains information intended for the addressee only.
It may be confidential and may be the subject of legal and/or professional
If you are not the addressee you are not authorised to disseminate,
distribute, copy or use this e-mail or any attachment to it
The content may be personal or contain personal opinions and unless
specifically stated or followed up in writing, the content cannot be taken
to form a contract or to be an expression of the County Council's position.
LCC reserves the right to monitor all incoming and outgoing email
LCC has taken reasonable steps to ensure that outgoing communications do
not contain malicious software and it is your responsibility to carry out
any checks on this email before accepting the email and opening