hi,

Why is pg_restore trying to put stuff into the pg_catalog schema of all places?

It's ignoring the schema specified in the pg_dump itself (`myschema`) and even my search_path (`public`).

$ psql stuff_development --command "show search_path"
 search_path
-------------
 public
(1 row)
$ pg_restore --list stuff.pg_dump
;
; Archive created at Fri Apr  4 00:55:50 2014
;     dbname: stuff_development
;     TOC Entries: 14
;     Compression: -1
;     Dump Version: 1.12-0
;     Format: CUSTOM
;     Integer: 4 bytes
;     Offset: 8 bytes
;     Dumped from database version: 9.3.4
;     Dumped by pg_dump version: 9.3.4
;
;
; Selected TOC Entries:
;
205; 1259 95675 TABLE myschema stuff_one myuser
[...]
3312; 0 95675 TABLE DATA myschema stuff_one myuser
[...]
$ pg_restore --verbose --no-owner --no-privileges --dbname stuff_development stuff.pg_dump
pg_restore: connecting to database for restore
pg_restore: creating TABLE stuff_one
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 205; 1259 95675 TABLE stuff_one myuser pg_restore: [archiver (db)] could not execute query: ERROR: permission denied to create "pg_catalog.stuff_one"
DETAIL:  System catalog modifications are currently disallowed.
    Command was: CREATE TABLE stuff_one (
    the_geom public.geometry
);

Thank you!
Seamus

--
Seamus Abshere, SCEA
https://github.com/seamusabshere


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to