Re: failures in pg_restore -- possibly corrupt archive

Поиск
Список
Период
Сортировка
От Caleb Access
Тема Re: failures in pg_restore -- possibly corrupt archive
Дата
Msg-id CADiaVNm4r-1nKEyHiebosdb5oEPAT93JNAnWvcv7URHXe6xtqw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: failures in pg_restore -- possibly corrupt archive  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
Дерево обсуждения 
The pg_dump and pg_restore look to be the same version on both boxes (
9.1.8 ).


The pg_dump looks like this:
pg_dump \  --host=myhost \  --port=5432 \  --username=myusername \  --format=c \  --file=backup_file.dump \  mydb

*Additional notes:*
  The pg_dump is running on a box with CentOS 6.4  / PostgreSQL 9.1.8  The pg_restore is then executed on a box with CentOS 5.9 / PostgreSQL
9.1.8
  The .dump file is 41 GB

A $yum list | grep libpq yields nothing on the CentOS 6.4 box but gives
this on 5.9
*$ yum list | grep libpq*  libpqxx.i386                             2.6.8-13.el5epel  libpqxx.x86_64                         2.6.8-13.el5epel  libpqxx-devel.i386                     2.6.8-13.el5epel  libpqxx-devel.x86_64                 2.6.8-13.el5                  epel


We have not tried without the -j but will give it a go.

Please let me know if there are any additional thoughts giving the new info
above.


On Thu, Jan 2, 2014 at 3:31 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
AccessDevelopment TEST <caleb.access@gmail.com> writes:
> I am attempting to restore a pg dump file and am getting this error message:
>   pg_restore: [custom archiver] could not find block ID 229750 in archive
> -- possibly corrupt archive
>   pg_restore: [custom archiver] could not find block ID 228874 in archive
> -- possibly corrupt archive
>   pg_restore: [archiver] worker process failed: exit code 1

> The pg_restore command used is:
>    pg_restore -j 12 -d mydb -h myhost -U username /restore/file.dump

This looks suspiciously like some old complaints about unsupported cases
in parallel restore.  Does it work if you omit the -j option?  If so,
what versions of pg_dump and pg_restore are you using exactly, and what
did the pg_dump command look like?

                        regards, tom lane

В списке pgsql-admin по дате отправления: