Postgres restore issue

From: "Vaidyanathaswamy, Anandsaikrishnan" <avaidyanathaswamy(at)corelogic(dot)com>
To: "pgsql-hackers(at)postgresql(dot)org" <pgsql-hackers(at)postgresql(dot)org>
Subject: Postgres restore issue
Date: 2018-10-25 19:27:07
Message-ID: BYAPR10MB29344F10DD9D3BE3C210020FA0F70@BYAPR10MB2934.namprd10.prod.outlook.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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;

******************************************************************************************
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

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Jesper Pedersen 2018-10-25 19:30:49 Re: PostgreSQL vs SQL/XML Standards
Previous Message Chapman Flack 2018-10-25 18:36:59 Re: PostgreSQL vs SQL/XML Standards