pg_restore returns always error if backup is greater than 2 GB
От | Andrus Moor |
---|---|
Тема | pg_restore returns always error if backup is greater than 2 GB |
Дата | |
Msg-id | 694E9ECF58794E0BB133FC89C47109B4@andrusnotebook обсуждение исходный текст |
Ответы |
Re: pg_restore returns always error if backup is greater than 2 GB
|
Список | pgsql-general |
I noticed that backups created by pg_dump are not usable if backup file size is greater than 2 GB. Backups are create in 8.1 I tried to restore them in 8.4. Backup contains many tables. There is a large table, attachme containing bytea field. This table grows rapidly. If .backup file size is bigger that 2 GB, pg_restore always fails for every table restored after that table: C:/Program Files/PostgreSQL/8.4/bin\pg_restore.exe --host localhost --port 5432 --username postgres --dbname mydb --verbose "\\ls\share\my cackups\backups\090703 my backup.backup" pg_restore: connecting to database for restore pg_restore: creating SCHEMA firma1 pg_restore: creating SCHEMA firma2 pg_restore: creating SCHEMA firma3 pg_restore: creating SCHEMA firma4 pg_restore: creating SCHEMA firma5 pg_restore: creating SCHEMA firma6 pg_restore: creating SCHEMA firma7 pg_restore: creating SCHEMA firma8 pg_restore: creating SCHEMA firma9 pg_restore: creating SCHEMA public pg_restore: creating COMMENT SCHEMA public pg_restore: creating PROCEDURAL LANGUAGE plpgsql pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 2214; 2612 16787 PROCEDURAL LANGUAGE plpgsql postgres pg_restore: [archiver (db)] could not execute query: ERROR: language "plpgsql" already exists Command was: CREATE PROCEDURAL LANGUAGE plpgsql; pg_restore: creating DOMAIN ebool pg_restore: creating FUNCTION dok_seq_trig() .... ... pg_restore: restoring data for table "attachme" pg_restore: restoring data for table "bilkaib" pg_restore: [custom archiver] found unexpected block ID (654399830) when reading data -- expected 12781 pg_restore: *** aborted because of error Process returned exit code 1. How to recover data from tables in backup after attachme table ? Andrus. Environment: Backups are created in PostgreSql 8.1 running in Windows pg_dump is used to create backup copies to Buffalo Linkstation Pro ls-320 GB external disk device ( \\ls ) connected to LAN backup command: pg_dump.exe -ibv -Z3 -f \\ls\backup\mybackup.backup -Fc -h localhost -U admin mydb What causes this ? is it Buffalo device, Windows/LAN or PostgreSql 8.1 issue ? Will upgrading to 8.4 fix this ?
В списке pgsql-general по дате отправления: