Postgres restore issue - Mailing list pgsql-hackers

Good morning,

First of all thanks for helping me ,

We have postgres running in 8.4.22, We have back up from 8.3.7

When I try to restore, All the tables are not restored, almost 60% of the tables not exist, Failed with the following errors.

Any help on this much appreciated.

I am using the below command for pg_restore

nohup pg_restore -c -U postgres  -d gpl_maps ~/gcs/PostgreSQL/gpl_maps_devgm01.bkup &

pg_restore: [archiver (db)] Error from TOC entry 7580; 0 49537695 TABLE DATA bldg_footprints gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "bldg_footprints" does not exist

    Command was: COPY bldg_footprints (gid, id, inbld_fid, bld_status, simbldflag, shape_leng, shape_le_1, shape_le_2, shape_area, et_id, the...

pg_restore: [archiver (db)] Error from TOC entry 7346; 0 17254 TABLE DATA block postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "block" does not exist

    Command was: COPY block (gid, blockgroup, bkg_key, the_geom) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 7443; 0 2897197 TABLE DATA brushfire_hazard_layer postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "brushfire_hazard_layer" does not exist

    Command was: COPY brushfire_hazard_layer (gid, id, risk_value, fire_risk, fipsstco, the_geom) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 7347; 0 17282 TABLE DATA ca059_census_tracts gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "ca059_census_tracts" does not exist

    Command was: COPY ca059_census_tracts (gid, censustrac, sdstag, the_geom) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 7348; 0 17294 TABLE DATA ca059_numbered_census_tracts gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "ca059_numbered_census_tracts" does not exist

    Command was: COPY ca059_numbered_census_tracts (gid, tractid, sdstag, the_geom) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 7628; 0 90569459 TABLE DATA calgary_disclaimer_boundary gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "calgary_disclaimer_boundary" does not exist

    Command was: COPY calgary_disclaimer_boundary (gid, id, area_km, the_geom) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 7576; 0 45204628 TABLE DATA congressional_dist_copy gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "congressional_dist_copy" does not exist

    Command was: COPY congressional_dist_copy (gid, statefp, cd113fp, geoid, namelsad, lsad, cdsessn, mtfcc, funcstat, aland, awater, intptla...

pg_restore: [archiver (db)] Error from TOC entry 7575; 0 45203723 TABLE DATA congressional_district gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "congressional_district" does not exist

    Command was: COPY congressional_district (gid, statefp, cd113fp, geoid, namelsad, lsad, cdsessn, mtfcc, funcstat, aland, awater, intptlat...

pg_restore: [archiver (db)] Error from TOC entry 7350; 0 17337 TABLE DATA continent postgres

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "continent" does not exist

    Command was: COPY continent (gid, continent, the_geom) FROM stdin;

pg_restore: [archiver (db)] Error from TOC entry 7507; 0 22422078 TABLE DATA coremls_geocoverage_county gpl-layer-loader

pg_restore: [archiver (db)] could not execute query: ERROR:  relation "coremls_geocoverage_county" does not exist

    Command was: COPY coremls_geocoverage_county (county_id, pctcvginfonet, pctcvginfonetmls, pctcvginfonetmlsvm, name, the_geom) FROM stdin;