Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
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 

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 

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



pgsql-admin by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group