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;
******************************************************************************************
This message may contain confidential or proprietary information intended only
for the use of the
addressee(s) named above or may contain information that is legally privileged.
If you are
not the intended addressee, or the person responsible for delivering it to the
intended addressee,
you are hereby notified that reading, disseminating, distributing or copying
this message is strictly
prohibited. If you have received this message by mistake, please immediately
notify us by
replying to the message and delete the original message and any copies
immediately thereafter.
Thank you.
******************************************************************************************
CLLD
