blinko-space / blinko

An open-source, self-hosted personal note tool prioritizing privacy, built using TypeScript .
https://blinko-demo.vercel.app/
GNU Affero General Public License v3.0
590 stars 46 forks source link

Error from `setting -> Import from .bko` #96

Open heng30 opened 13 hours ago

heng30 commented 13 hours ago

I install this application by docker and already update to the latest version. However, It show the below error, when I import from a backup file.

Command failed with exit code 1: pg_restore '--dbname=postgr
esql://postgres:mysecretpassword@blinko-postgres:5432/postgr
es' .blinko/pgdump/bak.sql
pg_restore: while PROCESSING TOC:
pg_restore: from TOC entry 3382; 0 16427 TABLE DATA config p
ostgres
pg_restore: error: COPY failed for table "config": ERROR: d
uplicate key value violates unique constraint "config_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY config, line 1
pg_restore: from TOC entry 3389; 0 16476 TABLE DATA schedule
dTask postgres
pg_restore: error: COPY failed for table "scheduledTask": ER
ROR: duplicate key value violates unique constraint "schedu
ledTask_pkey"
DETAIL: Key (name)=(Auto Archive Blinko) already exists.
CONTEXT: COPY scheduledTask, line 1
pg_restore: from TOC entry 3386; 0 16455 TABLE DATA tag post
gres
pg_restore: error: COPY failed for table "tag": ERROR: dupl
icate key value violates unique constraint "tag_pkey"
DETAIL: Key (id)=(1) already exists.
CONTEXT: COPY tag, line 1
pg_restore: warning: errors ignored on restore: 3
blinko-space commented 10 hours ago

It looks like there's a conflict in some configurations. Is the data all importing properly?