It seems like pg_restore tries to restore some extra data which you don’t own. Try to add -n public option to your pg_restore command line. It will tell pg_restore restore only contents of public schema. Your command line should looks like pg_restore -U username -c -n public -d database_name
After revisiting my question, I was able to get it to work after looking at how ConnectBot does it. Thanks Kenny and Jeffrey! It’s actually as easy as adding: FileBackupHelper hosts = new FileBackupHelper(this, “../databases/” + HostDatabase.DB_NAME); addHelper(HostDatabase.DB_NAME, hosts); to your BackupAgentHelper. The point I was missing was the fact that you’d have to use … Read more
Could be because of restoring SQL Server 2012 version backup file into SQL Server 2008 R2 or even less.
You should use the –no-owner option, this stops pg_restore trying to set the ownership of the objects to the original owner. Instead the objects will be owned by the user specified by –role createdb -p 5433 -T template0 db_name pg_restore -p 5433 –no-owner –role=owner2 -d db_name db_name.dump pg_restore doc
Unzip the file, and then import again.
On SQL Server Management Studio Right click Databases on left pane (Object Explorer) Click Restore Database… Choose Device, click …, and add your .bak file Click OK, then OK again Done.