Powershell command to restore a backup of the sockeye db locally here for development / testing

& "C:/data/code/postgres_14/bin/pg_restore" -U postgres -c -d sockeye "C:\temp\db-20230413160012664.backup"


NOTE: you may need to drop and create db outside of sockeye first if schema was changed locally from the backups copy schema,
in practice should always start with a fresh db restored *then* make schema changes while coding to save a hassle.
there's an info case for this if get stuck on it.

-- DROP DATABASE IF EXISTS sockeye;

CREATE DATABASE sockeye
    WITH
	TEMPLATE = template0
    OWNER = postgres
    ENCODING = 'UTF8'
    LC_COLLATE = 'English_United States.1252'
    LC_CTYPE = 'English_United States.1252'
    TABLESPACE = pg_default
    CONNECTION LIMIT = -1
    IS_TEMPLATE = False;