I am working with postgres 8.0.3 on suse linux 9.3.I want to restore data
from pg_dump backup.Previously it was working fine with the same dump.
But now it is giving the following error...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"sw_4904.operatorjob" does not exist
Command was: ALTER TABLE sw_4904.operatorjob OWNER TO postgres;
pg_restore: creating TABLE operatorjobhistory
pg_restore: [archiver (db)] Error from TOC entry 7577; 1259 11430376 TABLE
operatorjobhistory postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not
create directory "/usr/local/pgsql/data/pg_tblspc/17231/108986168": No
such file or directory
Command was: CREATE TABLE operatorjobhistory (
operatorid integer DEFAULT 0 NOT NULL,
operatorlotid integer DEFAULT 0 NOT NULL,
...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"sw_4904.operatorjobhistory" does not exist
Command was: ALTER TABLE sw_4904.operatorjobhistory OWNER TO postgres;
pg_restore: creating TABLE operatorlotmaster
pg_restore: [archiver (db)] Error from TOC entry 7573; 1259 11430364 TABLE
operatorlotmaster postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not
create directory "/usr/local/pgsql/data/pg_tblspc/17231/108986168": No
such file or directory
Command was: CREATE TABLE operatorlotmaster (
operatorlotid serial NOT NULL,
createdtime timestamp without time zone,
current...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"sw_4904.operatorlotmaster" does not exist
Command was: ALTER TABLE sw_4904.operatorlotmaster OWNER TO postgres;
pg_restore: executing SEQUENCE SET operatorlotmaster_operatorlotid_seq
pg_restore: [archiver (db)] Error from TOC entry 19889; 0 0 SEQUENCE SET
operatorlotmaster_operatorlotid_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"operatorlotmaster" does not exist
Command was: SELECT
pg_catalog.setval(pg_catalog.pg_get_serial_sequence('operatorlotmaster',
'operatorlotid'), 40, true);
pg_restore: creating TABLE samplelotmaster
pg_restore: [archiver (db)] Error from TOC entry 7575; 1259 11430371 TABLE
samplelotmaster postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not
create directory "/usr/local/pgsql/data/pg_tblspc/17231/108986168": No
such file or directory
Command was: CREATE TABLE samplelotmaster (
samplelotid serial NOT NULL,
createdtime timestamp without time zone,
createdby b...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"sw_4904.samplelotmaster" does not exist
Command was: ALTER TABLE sw_4904.samplelotmaster OWNER TO postgres;
pg_restore: executing SEQUENCE SET samplelotmaster_samplelotid_seq
pg_restore: [archiver (db)] Error from TOC entry 19890; 0 0 SEQUENCE SET
samplelotmaster_samplelotid_seq postgres
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"samplelotmaster" does not exist
Command was: SELECT
pg_catalog.setval(pg_catalog.pg_get_serial_sequence('samplelotmaster',
'samplelotid'), 5, true);
pg_restore: creating TABLE samplelotqcone
pg_restore: [archiver (db)] Error from TOC entry 7578; 1259 11430382 TABLE
samplelotqcone postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not
create directory "/usr/local/pgsql/data/pg_tblspc/17231/108986168": No
such file or directory
Command was: CREATE TABLE samplelotqcone (
imagedetailid bigint DEFAULT 0 NOT NULL,
defectstatus smallint DEFAULT 0 NOT NULL,
...
pg_restore: [archiver (db)] could not execute query: ERROR: relation
"sw_4904.samplelotqcone" does not exist
Command was: ALTER TABLE sw_4904.samplelotqcone OWNER TO postgres;
pg_restore: creating TABLE sampleoperatorjob
pg_restore: [archiver (db)] Error from TOC entry 7579; 1259 11430388 TABLE
sampleoperatorjob postgres
pg_restore: [archiver (db)] could not execute query: ERROR: could not
create directory "/usr/local/pgsql/data/pg_tblspc/17231/108986168": No
such file or directory
Command was: CREATE TABLE sampleoperatorjob (
operatorid bigint DEFAULT 0 NOT NULL,
samplelotid smallint DEFAULT 0 NOT NULL,
...
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
