Re: pg_ [dump & restore] invalid archive problem

Hi,

I had a similar problem a while back,

I think the way you've dumped them is fine, to restore them however you need
to use the psql command

psql -U postgres YourDatabase < mydb.tar

make sure YourDatabase is created and empty before you run this command, and
change postgres to whatever user you have.

Hope this helps

Roy

-----Original Message-----
From: John-Paul Delaney [mailto:John-Paul.Delaney@wfp.org]
Sent: 04 November 2004 10:29
To: pgsql-novice@postgresql.org
Subject: [NOVICE] pg_ [dump & restore] invalid archive problem

Hello List... I'd like to move a db containing large objects from one db to
another.
Using the command syntax directly from man pg_dump:

      pg_dump -Ft -b mydb > mydb.tar

      pg_restore -d mydb mydb.tar

I invariably (tried various attempts) get the following error:
"pg_restore: [archiver] input file does not appear to be a valid archive"

Any help much appreciated.
/j-p.



---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@postgresql.org so that your
      message can get through to the mailing list cleanly


********************
This e-mail contains information intended for the addressee only.
It may be confidential and may be the subject of legal and/or professional privilege.
If you are not the addressee you are not authorised to disseminate, distribute, copy or use this e-mail or any
attachmentto it 
The content may be personal or contain personal opinions and unless specifically stated or followed up in writing, the
contentcannot 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
responsibilityto carry out any checks on this email before accepting the email and opening attachments. 
********************