CREATE DATABASE ... WITH TEMPLATE seems to lose relations in PostgreSQL
Thanks to @a_horse_with_no_name for leading me to this answer.

The relations appear to be missing because Postgres does not copy the search_path to the new database.  If you explicitly look in the specific schema, all relations are there:

\dt &lt;schema&gt;.*


So, the search_path needs to be explicitly set on the new database:

ALTER DATABASE gcis_rollback2 SET SEARCH_PATH gcis_metadata, public


@Erwin Brandstetter also provides more information on viewing the search_path for roles/dbs.