sapphire1
11-26-2009, 09:01 PM
I reinstalled my computer and tried to restore a database I made a backup of but I am getting errors.
pg_restore: connecting to database for restore
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 425; 2612 16386 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: [custom archiver] could not uncompress data: incorrect data check
pg_restore: *** aborted because of error
I was using PostgreSQL 8.3 and for this reinstall I am using 8.3
The backup is the only thing I have from the computer before I reformatted.
I desperately need to get this database restored.
Please help !
pg_restore: connecting to database for restore
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 425; 2612 16386 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: [custom archiver] could not uncompress data: incorrect data check
pg_restore: *** aborted because of error
I was using PostgreSQL 8.3 and for this reinstall I am using 8.3
The backup is the only thing I have from the computer before I reformatted.
I desperately need to get this database restored.
Please help !