Arindam <arindam.mukerjee@xxxxxxxxx> writes: > In all the above cases, this is the error I get: > pg_restore: [archiver (db)] could not execute query: ERROR: cannot > drop schema public because other objects depend on it > HINT: Use DROP ... CASCADE to drop the dependent objects too. > Command was: DROP SCHEMA public; Don't use the -c option. Or else don't load your private additions until after you restore. regards, tom lane