problems with pg_dump/pg_restore

From: Mirek Hankus <M(dot)Hankus(at)ce3(dot)pl>
To: pgsql-admin(at)postgresql(dot)org
Subject: problems with pg_dump/pg_restore
Date: 2002-01-15 20:53:34
Message-ID: 3C4496CE.3000707@ce3.pl
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message David Stanaway 2002-01-15 22:29:20 Re: Monitoring database
Previous Message Bruce Momjian 2002-01-15 16:55:40 Re: Fine tuning mem sort, shared buffer