pg_restore problem
От | Michael Andreasen |
---|---|
Тема | pg_restore problem |
Дата | |
Msg-id | 447B75CD.1060606@dunlops.com обсуждение исходный текст |
Ответы |
Re: pg_restore problem
|
Список | pgsql-bugs |
I have a problem restoring our large database. This has only stared happening since we moved to 8.1.x We are currently on 8.1.3. We perform an over night dump of the database as follows; pg_dump -Ft $db | bzip2 > $db.dump.tbz This happens fine, without any errors. On our backup machine also running 8.1.3 we do the following; createdb $db bzip2 -d -c $db.dump.tbz | pg_restore -i -O -d $db However, after a while we get this error; pg_restore: [tar archiver] could not find header for file 3765.dat in tar archive Our bzip2ed database is 1.2G so it's not small. We also run the same procedure on a number of other smaller database and have no problems at all. However, we are now in the unhandy position of having our main operational database that we can backup, but not restore! Help.
В списке pgsql-bugs по дате отправления: