search

postgrespro / imgsmlr

Similar images search for PostgreSQL
Other
257 stars 41 forks source link

postgresql restore database, pg_restore: [archiver (db)] COPY failed for table "pat": ERROR: pattern_in is not implemented #2

Closed jiejia closed 6 years ago

jiejia commented 7 years ago 
bash-4.1$ pg_restore -d test /home/backup/test4.sql.gz 
pg_restore: [archiver (db)] Error while PROCESSING TOC:

pg_restore: [archiver (db)] Error from TOC entry 2408; 0 666136 TABLE DATA pat postgres
pg_restore: [archiver (db)] COPY failed for table "pat": ERROR:  pattern_in is not implemented
CONTEXT:  COPY pat, line 1, column ptn: "((0.244171, 0.008272, 0.021515, -0.012174, 0.068765, 0.076409, 0.016820, 0.021921, 0.114738, 0.12366..."
pg_restore: [archiver (db)] Error from TOC entry 2445; 0 4877471 TABLE DATA pat_303816 postgres
pg_restore: [archiver (db)] COPY failed for table "pat_303816": ERROR:  pattern_in is not implemented
CONTEXT:  COPY pat_303816, line 1, column ptn: "((0.446228, -0.151998, -0.054444, -0.095391, 0.027121, 0.028324, 0.017388, 0.133117, 0.008461, 0.012..."
pg_restore: [archiver (db)] Error from TOC entry 2441; 0 4800536 TABLE DATA pat_402653 postgres
pg_restore: [archiver (db)] COPY failed for table "pat_402653": ERROR:  pattern_in is not implemented
CONTEXT:  COPY pat_402653, line 1, column ptn: "((0.505515, 0.040819, 0.057495, 0.044649, 0.065036, 0.021012, 0.006341, 0.045162, 0.061616, 0.085675..."
pg_restore: [archiver (db)] Error from TOC entry 2449; 0 4878143 TABLE DATA pat_452238 postgres
pg_restore: [archiver (db)] COPY failed for table "pat_452238": ERROR:  pattern_in is not implemented
CONTEXT:  COPY pat_452238, line 1, column ptn: "((0.124739, -0.015536, 0.045421, 0.013990, 0.000782, 0.013343, 0.018824, 0.002218, 0.009941, 0.01699..."
WARNING: errors ignored on restore: 4
CyberShadow commented 7 years ago

From looking at the source code, this looks like an intentional omission.

You will need to recreate the index using the original images.

akorotkov commented 7 years ago

Hi! It's oversight. Needs to be fixed...

akorotkov commented 7 years ago

Fixed in 5eef649a. Please, check.