Why can't I restore the DB from an SQL dump in PostgreSQL 9.4 (problem with dblink)?
The comment from @a_horse_with_no_name helped me solve the issue i.e., the extension was not installed in the right schema when attempting to restore the DB. When moved to the right schema the restore finished with no errors.