Skip to content

Instantly share code, notes, and snippets.

View hepiyellow's full-sized avatar

Erez Makavy hepiyellow

  • On A Sabbatical Year
  • Israel
View GitHub Profile
@hepiyellow
hepiyellow / gist:3df7c3b43556f38b3dd36d4a867dbd00
Created January 7, 2024 11:39
Restore DB backup errors apiserver_01062024.bak
pg_restore -U apiserver -d apiserver --no-owner --role=apiserver apiserver_01062024.bak
pg_restore: error: could not execute query: ERROR: type "public.orgstatus" does not exist
LINE 4: status public.orgstatus NOT NULL,
^
Command was: CREATE TABLE public.ui_organization (
id integer NOT NULL,
flags character varying,
status public.orgstatus NOT NULL,
created_at timestamp without time zone NOT NULL,
name character varying NOT NULL