CLI "database restore" command should drop database
Created:
10/2/2025 5:08:34 AM by Alana Tripp
Status:
Open
Last pulled:
10/7/2025 5:25:54 AM
Description:
After verifying file exists and prior to running `pg_restore`, the target database should be dropped first. Otherwise this error occurs:
```
Restoring database from backup file D:\Backup_PostgreSQL\ProGetDatabaseBackup_20251001_185159.ahbak...
pg_restore: connecting to database for restore
pg_restore: creating FUNCTION "public.ApiKeys_CreateOrUpdateApiKey(character varying, text, xml, character varying, jsonb, timestamp with time zone, bytea, integer)"
```