Hi,
I’m trying to restore a backup. But it get error:
pg_restore: dropping CONSTRAINT Users Users_pkey
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3022; 2606 16420 CONSTRAINT Users Users_pkey hollaex
pg_restore: error: could not execute query: ERROR: cannot drop constraint Users_pkey on table public.“Users” because other objects depend on it
DETAIL: constraint Stakes_user_id_fkey on table public.“Stakes” depends on index public.“Users_pkey”
constraint Stakes_account_id_fkey on table public.“Stakes” depends on index public.“Users_pkey”
.
.
.
pg_restore: creating TABLE “public.Users”
pg_restore: error: could not execute query: ERROR: relation “Users” already exists
Command was: CREATE TABLE public.“Users” (
id integer NOT NULL,
email character varying(255) NOT NULL,
password character varying(255) NOT NULL,
full_name character varying(255) DEFAULT ‘’::character varying,
gender boolean DEFAULT false,
nationality character varying(255) DEFAULT ‘’::character varying,
dob timestamp with time zone,
phone_number character varying(255) DEFAULT ‘’::character varying,
crypto_wallet jsonb DEFAULT ‘{}’::jsonb,
verification_level integer DEFAULT 0,
note character varying(255) DEFAULT ‘’::character varying,
created_at timestamp with time zone DEFAULT now(),
updated_at timestamp with time zone DEFAULT now(),
is_admin boolean DEFAULT false,
is_supervisor boolean DEFAULT false,
is_support boolean DEFAULT false,
is_kyc boolean DEFAULT false,
is_communicator boolean DEFAULT false,
otp_enabled boolean DEFAULT false,
address jsonb DEFAULT ‘{“city”: “”, “address”: “”, “country”: “”, “postal_code”: “”}’::jsonb,
bank_account jsonb DEFAULT ‘[]’::jsonb,
id_data jsonb DEFAULT ‘{“type”: “”, “number”: “”, “provided”: false, “verified”: false, “issued_date”: “”, “expiration_date”: “”}’::jsonb,
activated boolean DEFAULT false,
settings jsonb DEFAULT ‘{“language”: “en”}’::jsonb,
username character varying(255) DEFAULT ‘’::character varying,
flagged boolean DEFAULT false,
affiliation_code character varying(255) DEFAULT ‘’::character varying,
affiliation_rate double precision DEFAULT ‘0’::double precision,
network_id integer,
email_verified boolean DEFAULT false,
discount double precision DEFAULT ‘0’::double precision,
meta jsonb DEFAULT ‘{}’::jsonb
);
pg_restore: creating SEQUENCE “public.Users_id_seq”
…
pg_restore: creating CONSTRAINT “public.Users Users_pkey”
pg_restore: from TOC entry 3022; 2606 16420 CONSTRAINT Users Users_pkey hollaex
pg_restore: error: could not execute query: ERROR: multiple primary keys for table “Users” are not allowed
Command was: ALTER TABLE ONLY public.“Users”
ADD CONSTRAINT “Users_pkey” PRIMARY KEY (id);