인프런 커뮤니티 질문&답변

안녕하세요 pgAdmin4 설치 부분을 하고있습니다.

1. 17버전에서 Reference 설정하고 시도했을 때, 안됨

2. 15버전으로 설치하고 Reference설정 후 시도해도 안됨

3. 이 때 해 볼만한 방안이 있을까요? 바쁘신데 한 번 봐주시면 감사하겠습니다. 껄껄

아래 에러 내용입니다

.

pg_restore: ۾ ͺ ̽

pg_restore: EXTENSION "adminpack"

pg_restore: COMMENT "EXTENSION adminpack"

pg_restore: TABLE "public.gangnamgu_population"

pg_restore: TOC ó ϴ :

pg_restore: 215 TOC ׸񿡼 ; 1259 24662 TABLE gangnamgu_population postgres

pg_restore: : could not execute query: 오류: "gangnamgu_population" 이름의 릴레이션(relation)이 이미 있습니다

: CREATE TABLE public.gangnamgu_population (

administrative_agency character varying,

total_population integer,

male_population integer,

female_population integer,

sex_ratio double precision,

number_of_households integer,

number_of_people_per_household double precision,

id integer NOT NULL

);

pg_restore: SEQUENCE "public.gangnamgu_population_id_seq"

pg_restore: 216 TOC ׸񿡼 ; 1259 24667 SEQUENCE gangnamgu_population_id_seq postgres

pg_restore: : could not execute query: 오류: "gangnamgu_population_id_seq" 이름의 릴레이션(relation)이 이미 있습니다

: CREATE SEQUENCE public.gangnamgu_population_id_seq

AS integer

START WITH 1

INCREMENT BY 1

NO MINVALUE

NO MAXVALUE

CACHE 1;

pg_restore: SEQUENCE OWNED BY "public.gangnamgu_population_id_seq"

pg_restore: DEFAULT "public.gangnamgu_population id"

pg_restore: "public.gangnamgu_population" ̺ ڷḦ ó

pg_restore: 3319 TOC ׸񿡼 ; 0 24662 TABLE DATA gangnamgu_population postgres

pg_restore: : "gangnamgu_population" ̺ COPY : 오류: 중복된 키 값이 "gangnamgu_population_pkey" 고유 제약 조건을 위반함

: (id)=(2) 키가 이미 있습니다.

: gangnamgu_population 복사, 1번째 줄

pg_restore: : SEQUENCE SET gangnamgu_population_id_seq

pg_restore: CONSTRAINT "public.gangnamgu_population gangnamgu_population_pkey"

pg_restore: 3176 TOC ׸񿡼 ; 2606 24675 CONSTRAINT gangnamgu_population gangnamgu_population_pkey postgres

pg_restore: : could not execute query: 오류: "gangnamgu_population" 테이블에는 이미 기본키가 있습니다

: ALTER TABLE ONLY public.gangnamgu_population

ADD CONSTRAINT gangnamgu_population_pkey PRIMARY KEY (id);

pg_restore: : ۾ õǾ : 4