Arindam <arindam(dot)mukerjee(at)gmail(dot)com> 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