Quiz: PostgreSQL

Read the output

What do you do to bring this dump up in crm_check?

$ pg_restore -d crm_check crm.sql
pg_restore: error: input file appears to be a text format dump. Please use psql.
$ file crm.sql
crm.sql: ASCII text

• A Take a new dump of crm with -Fc and restore it.
• B pg_restore -Fc -d crm_check crm.sql
• C pg_restore --list crm.sql to find the error in the file.
• D psql -d crm_check -f crm.sql