pg_restore returns always error if backup is greater than 2 GB

From: "Andrus Moor" <kobruleht2(at)hot(dot)ee>
To: <pgsql-general(at)postgresql(dot)org>
Subject: pg_restore returns always error if backup is greater than 2 GB
Date: 2009-08-19 08:52:28
Message-ID: 694E9ECF58794E0BB133FC89C47109B4@andrusnotebook
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ?

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Clemens Schwaighofer 2009-08-19 09:00:41 Re: Postgre RAISE NOTICE and PHP
Previous Message Albe Laurenz 2009-08-19 07:47:43 Re: PQgetlength vs. octet_length()