problem with pg_restore

From: jayati(dot)biswas(at)cmcltd(dot)com
To: pgsql(dot)admin(at)googlegroups(dot)com, majordomo(at)postgresql(dot)org
Cc: pgsql-general(at)postgresql(dot)org, dmagick(at)gmail(dot)com, pgsql-general(at)postgresql(dot)org, thomas(dot)barnow(at)native-instruments(dot)de
Subject: problem with pg_restore
Date: 2006-05-19 10:29:48
Message-ID: 33375.203.197.96.132.1148034588.squirrel@mail.cmcltd.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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,
...

Browse pgsql-general by date

  From Date Subject
Next Message Oliver A. Rojo 2006-05-19 10:58:40 Re: invalid byte sequence for encoding error
Previous Message Qingqing Zhou 2006-05-19 10:02:14 Re: Insert into partition table hangs