On 11/21/2016 03:34 PM, Fran ... wrote:
Hi Adrian, I followed you link and I had again errors:
What was the command you used?
/pg_restore: [archiver (db)] Error from TOC entry 4368; 2606 151317 FK CONSTRAINT type_id_3940becf ownersuser/ /pg_restore: [archiver (db)] could not execute query: ERROR: constraint "type_id_3940becf" of relation "store" does not exist/ / Command was: ALTER TABLE ONLY public.store DROP CONSTRAINT type_id_3940becf;/
Can't DROP what does not exist. The end result is the same anyway. You can avoid this type of error with --if-exists.
/ / /pg_restore: [archiver (db)] Error from TOC entry 4273; 1259 1179680 INDEX profile_id owneruser/ /pg_restore: [archiver (db)] could not execute query: ERROR: index "profile_id" does not exist/ / Command was: DROP INDEX public.profile_id;/
See above.
/ / /pg_restore: [archiver (db)] Error from TOC entry 4751; 0 0 COMMENT EXTENSION plpgsql / /pg_restore: [archiver (db)] could not execute query: ERROR: must be owner of extension plpgsql/ / Command was: COMMENT ON EXTENSION plpgsql IS 'PL/pgSQL procedural language';/
Not adding a COMMENT, not necessarily fatal. Best guess plpgsql is actually installed, have you checked?
/ / /pg_restore: [archiver (db)] Error from TOC entry 4756; 0 0 USER MAPPING USER MAPPING dwhuser SERVER pg_rest postgres/ /pg_restore: [archiver (db)] could not execute query: ERROR: role "user" does not exist/ / Command was: CREATE USER MAPPING FOR user SERVER pg_rest OPTIONS (/ / password 'XXXXX',/ / "user" 'user'/ /);/
This is probably because you could not import the global roles from your original database.
Regards.
-- Adrian Klaver adrian.klaver@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
