When restoring a dump like this:pg_restore --clean --create --exit-on-error --dbname=test test.tarthese error messages got printed out:pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 21; 2615 80924 SCHEMA test test pg_restore: [archiver (db)] could not execute query: ERROR: schema "test" already exists Command was: CREATE SCHEMA test;but when:select schema_name from information_schema.schemata;these got printed outschema_name -------------------- pg_toast pg_temp_1 pg_toast_temp_1 pg_catalog public information_schemaIt seems like schema "test" doesn't exist yet,why do I got this kind of error?
When restoring a dump like this:
pg_restore --clean --create --exit-on-error --dbname=test test.tar
these error messages got printed out:
pg_restore: [archiver (db)] Error while PROCESSING TOC: pg_restore: [archiver (db)] Error from TOC entry 21; 2615 80924 SCHEMA test test pg_restore: [archiver (db)] could not execute query: ERROR: schema "test" already exists Command was: CREATE SCHEMA test;
but when:
select schema_name from information_schema.schemata;
these got printed out
schema_name -------------------- pg_toast pg_temp_1 pg_toast_temp_1 pg_catalog public information_schema
It seems like schema "test" doesn't exist yet,why do I got this kind of error?
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных