Hi,all:
      I create a schema (sch1)  in the database of db1, and I also create a 
table sch1.t1, then I use the comand "pg_dump -d db1 -Fd -f dir1" to back up 
the database of db1; at lase  I drop the schema of sch1;   I want to restore 
the schema sch1, but when I execute the command "pg_restore  -d db1 -Fd dir1 -n 
sch1", get error, just like below.  
     I just want to test  the parameter of "-n" for pg_restore,  how can do to 
use the pg_restore correctly?


[wln@localhost test]$ pg_restore  -d db1 -Fd dir1 -n sch1
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 171; 1259 24669 TABLE t1 wln
pg_restore: [archiver (db)] could not execute query: ERROR:  permission denied 
to create "pg_catalog.t1"
DETAIL:  System catalog modifications are currently disallowed.
    Command was: CREATE TABLE t1 (
    id integer
);






pg_restore: [archiver (db)] could not execute query: ERROR:  schema "sch1" does 
not exist
    Command was: ALTER TABLE sch1.t1 OWNER TO wln;




pg_restore: [archiver (db)] Error from TOC entry 2777; 0 24669 TABLE DATA t1 wln
pg_restore: [archiver (db)] could not execute query: ERROR:  relation "t1" does 
not exist
    Command was: COPY t1 (id) FROM stdin;


WARNING: errors ignored on restore: 3




[wln@localhost test]$ pg_restore  -d db1 -Fd dir1 -n sch1 -l
;
; Archive created at Fri Sep 26 10:26:43 2014
;     dbname: db1
;     TOC Entries: 11
;     Compression: -1
;     Dump Version: 1.12-0
;     Format: DIRECTORY
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 9.3beta2
;     Dumped by pg_dump version: 9.3beta2
;
;
; Selected TOC Entries:
;
171; 1259 24669 TABLE sch1 t1 wln
2777; 0 24669 TABLE DATA sch1 t1 wln




Thanks,
 wanglin







Reply via email to