parkingos / parkingos_local Goto Github PK

SQL有问题吧

backup文件无法还原，工具中还原时出现乱码。

I can not restore the file postgres.backup.

D:\pgadmin\runtime\pg_restore.exe --host "localhost" --port "5432" --username "postgres" --no-password --role "tracqdev" --dbname "zldetclocal" --verbose "C:\Users\wzhsh90\Desktop\POSTGR~1.BAC"

Start time: Tue Aug 01 2017 17:31:45 GMT+0800 (**标准时)
pg_restore: connecting to database for restore
pg_restore: implied data-only restore
pg_restore: processing data for table "public.area_ibeacon_tb"
pg_restore: [archiver (db)] Error while PROCESSING TOC:
pg_restore: [archiver (db)] Error from TOC entry 3273; 0 35538 TABLE DATA area_ibeacon_tb postgres
pg_restore: [archiver (db)] could not execute query: ������: ������ "area_ibeacon_tb" ���������
Command was: COPY area_ibeacon_tb (id, ibcid, comid, reg_time, state, pass, major, minor, lng, lat) FROM stdin;

pg_restore: processing data for table "public.auth_tb"
pg_restore: [archiver (db)] Error from TOC entry 3274; 0 35542 TABLE DATA auth_tb postgres
pg_restore: [archiver (db)] could not execute query: ������: ������ "auth_tb" ���������
Command was: COPY auth_tb (id, nname, state, isparent, nid, pid) FROM stdin;

pg_restore: processing data for table "public.bizcircle_tb"
pg_restore: [archiver (db)] Error from TOC entry 3275; 0 35547 TABLE DATA bizcircle_tb postgres
pg_restore: [archiver (db)] could not execute query: ������: ������ "bizcircle_tb" ���������
Command was: COPY bizcircle_tb (id, name, resume, state, create_time) FROM stdin;
and so on.