Created attachment 1206800 [details] backup.log Description of problem: engine-setup --mode=restore for remote EDB returns 'FATAL: Errors while restoring database engine', but all tables and views are created and in log are only errors on COMMENT EXTENSION and warnings Version-Release number of selected component (if applicable): ovirt-engine-tools-backup-4.0.5-0.1.el7ev.noarch Steps to Reproduce: 1. have backup of remote EDB and prepared empty engine remote database with created role engine 2. copy pg_dump/pg_restore from EDB to engine and put it in /usr/bin instead of the postgresql ones 3. engine-backup --mode=restore --scope=db --file=/tmp/engine3-edb-201609230935.bck --log=/tmp/backup.log --change-db-credentials --db-host=XX.XX.XX.XX --db-port=XXXX --db-user=engine --db-password=XX --db-name=engine --no-restore-permissions see log attached
See http://stackoverflow.com/questions/10169203/postgresql-9-1-pg-restore-error-regarding-plpgsql Is it possible to add to engine-backup support of the -n option such that we will skip objects that are not on the public schema upon restore ?
(In reply to Eli Mesika from comment #1) > See > http://stackoverflow.com/questions/10169203/postgresql-9-1-pg-restore-error- > regarding-plpgsql > > Is it possible to add to engine-backup support of the -n option such that we > will skip objects that are not on the public schema upon restore ? We already agreed in bug 1378921 to not do this. We already filter out some of the errors. I suspect that we only need to add there a few lines for edb-specific extensions, but want to make sure first. I am trying to register there to get a free trial, then try this myself.