problem with pg_restore

Поиск
Список
Период
Сортировка
От jayati.biswas@cmcltd.com
Тема problem with pg_restore
Дата
Msg-id 33375.203.197.96.132.1148034588.squirrel@mail.cmcltd.com
обсуждение исходный текст
Список 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,
    ...





В списке pgsql-general по дате отправления:

Предыдущее
От: "Siah"
Дата:
Сообщение: SQL & Binary Data Questions
Следующее
От: Csaba Nagy
Дата:
Сообщение: Re: allow LIMIT in UPDATE and DELETE