Re: Problem restoring with pg_dump

[Peter Wilson <petew@xxxxxxxxxxxxxxxx>]

Tom Lane wrote:

Peter Wilson <petew@xxxxxxxxxxxxxxxx> writes:
  

Tom Lane wrote:
    

Could you show us the unmodified output from pg_restore -l, as well as
the edits you made to produce the -L script?
      

Raw output from pg_restore -l is as follows:
    

Hm, this shows only data entries.  Was the original pg_dump made with -a,
or did you use -a in the pg_restore -l command?  If the latter, could we
see the full -l output?  I didn't have any luck trying to reproduce this
behavior, so I'm supposing it depends on something you haven't shown us...
  

The dump was data-only :
    pg_dump -data-only -U user --format=c --compress=9 whitebeam

I have a script that builds the empty database on the restore machine then fills it from the pg_dump file.

This approach has worked perfectly for a year or so.

Partly the question might be 'what does the error message mean?' - it almost looks like do_restore doesn't think it has a real file underneath it, instead something that only provides sequential access.

I installed from RPMs. Since I originally posted I've tried the following :
+  installed the 8.1.5 RPMs - same result
+  build 8.1.5 from source - same result
+  run pg_restore from another machine - connecting to the server having problems - same result
+ Tried in a different machine - same result

To make sure there isn't a difference between the database structures I've now done a pg_dump --schema-only --format=p and then used that to create the database before importing the data. Same result again. The data file itself is just about 1.2 Gbytes in size.

Tonights backup I'm going to remove the --data-only to see whether I have any more luck.

			regards, tom lane
  

Thanks
Pete

--

---

Peter Wilson T: 01414 160505 M: 07796 656566 http://www.yellowhawk.co.uk

The information in this email is confidential and is intended for the addressee/s only. Access to this email by anyone else is unauthorised. If you are not the intended recipient, you must not read, use or disseminate the information contained in or attached to this email.

--

---

Peter Wilson T: 01414 160505 M: 07796 656566 http://www.yellowhawk.co.uk

The information in this email is confidential and is intended for the addressee/s only. Access to this email by anyone else is unauthorised. If you are not the intended recipient, you must not read, use or disseminate the information contained in or attached to this email.