Re: [GENERAL] pg_restore tells schema “test” already exists but it isn't actually

2015-11-12 Thread Adrian Klaver
On 11/12/2015 06:53 PM, Alex Luya wrote: 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 whilePROCESSING TOC:pg_restore:[archiver (db)]Error fromTOC entry 21;261580924SC

[GENERAL] Re: [GENERAL] pg_restore tells schema “test” already exists but it isn't actually

2015-11-12 Thread Melvin Davidson
Try this instead: SELECT current_database(); SELECT nspname FROM pg_namespace ORDER BY 1; Also, What is the exact command you are using with pg_restore? On Thu, Nov 12, 2015 at 9:53 PM, Alex Luya wrote: > When restoring a dump like this: > > pg_restore --clean --create --exit-on-error --dbname=

[GENERAL] pg_restore tells schema “test” already exists but it isn't actually

2015-11-12 Thread Alex Luya
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