Restore DB backup errors apiserver_01062024.bak

gistfile1.txt

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
);


pg_restore: error: could not execute query: ERROR:  relation "public.ui_organization" does not exist
Command was: ALTER SEQUENCE public.organization_id_seq OWNED BY public.ui_organization.id;


pg_restore: error: could not execute query: ERROR:  relation "public.ui_organization" does not exist
Command was: ALTER TABLE ONLY public.ui_organization ALTER COLUMN id SET DEFAULT nextval('public.organization_id_seq'::regclass);


pg_restore: error: could not execute query: ERROR:  relation "public.ui_organization" does not exist
Command was: COPY public.ui_organization (id, flags, status, created_at, name) FROM stdin;
pg_restore: error: could not execute query: ERROR:  relation "public.ui_organization" does not exist
Command was: ALTER TABLE ONLY public.ui_organization
    ADD CONSTRAINT organization_pkey PRIMARY KEY (id);


pg_restore: error: could not execute query: ERROR:  operator class "public.gin_trgm_ops" does not exist for access method "gin"
Command was: CREATE INDEX trgm_idx_fact_organization_name ON public.fact_organization USING gin (name public.gin_trgm_ops);


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_curated TO apiserver;
GRANT SELECT ON TABLE public.fact_curated TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_deal TO apiserver;
GRANT SELECT ON TABLE public.fact_deal TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_education TO apiserver;
GRANT SELECT ON TABLE public.fact_education TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_event TO apiserver;
GRANT SELECT ON TABLE public.fact_event TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_investment TO apiserver;
GRANT SELECT ON TABLE public.fact_investment TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_investor TO apiserver;
GRANT SELECT ON TABLE public.fact_investor TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_job TO apiserver;
GRANT SELECT ON TABLE public.fact_job TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_map TO apiserver;
GRANT SELECT ON TABLE public.fact_map TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_metainfo TO apiserver;
GRANT SELECT ON TABLE public.fact_metainfo TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_organization TO apiserver;
GRANT SELECT ON TABLE public.fact_organization TO modeler;


pg_restore: error: could not execute query: ERROR:  role "modeler" does not exist
Command was: GRANT SELECT ON TABLE public.fact_people TO apiserver;
GRANT SELECT ON TABLE public.fact_people TO modeler;


pg_restore: error: could not execute query: ERROR:  relation "public.ui_organization" does not exist
Command was: GRANT ALL ON TABLE public.ui_organization TO source_ingestor;
GRANT SELECT ON TABLE public.ui_organization TO fact_processor;


pg_restore: warning: errors ignored on restore: 18