problems with pg_dump/pg_restore - Mailing list pgsql-admin

From Mirek Hankus
Subject problems with pg_dump/pg_restore
Date
Msg-id 3C4496CE.3000707@ce3.pl
Whole thread Raw
Responses Re: problems with pg_dump/pg_restore
List pgsql-admin

Hello !

   I'm trying to dump postgresql 7.1.3 database and restore it in 7.2b4.
Databases are located
on different hosts. The problem is that when I run command

pg_dump databasename --verbose -b -Ft  -h otherhost | pg_restore -d
databasename

after some tables are copied error occures

pg_dump: [tar archiver] could not write to tar member (wrote 1087,
attempted 5365)
pg_dump: *** aborted because of error
pg_restore: [tar archiver] could not find header for file 179.dat in tar
archive

command is run on host with Postgresql 7.2b4 installed.  What is wrong ??

BR
  Mirek


pgsql-admin by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Fine tuning mem sort, shared buffer
Next
From: David Stanaway
Date:
Subject: Re: Monitoring database