node.js db-migrate create extension issue

Question

I use the db-migrate to create the table. I have a sql statement.
CREATE EXTENSION IF NOT EXISTS pgcrypto;
But I got a error.

[ERROR] AssertionError [ERR_ASSERTION]: ifError got unwanted exception: could not load library "/Users/manlokwong/PostgreSQL/pg96/lib/postgresql/pgcrypto.so": dlopen(/Users/manlokwong/PostgreSQL/pg96/lib/postgresql/pgcrypto.so, 10): Library not loaded: /opt/pgbin-build/pgbin/shared/osx_64/lib/libcrypto.1.0.0.dylib Referenced from: /Users/manlokwong/PostgreSQL/pg96/lib/postgresql/pgcrypto.so Reason: image not found at Connection.parseE (/usr/local/lib/node_modules/db-migrate-pg/node_modules/pg/lib/connection.js:553:11) at Connection.parseMessage (/usr/local/lib/node_modules/db-migrate-pg/node_modules/pg/lib/connection.js:378:19) at Socket. (/usr/local/lib/node_modules/db-migrate-pg/node_modules/pg/lib/connection.js:119:22) at Socket.emit (events.js:182:13) at addChunk (_stream_readable.js:280:12) at readableAddChunk (_stream_readable.js:265:11) at Socket.Readable.push (_stream_readable.js:220:10) at TCP.onread (net.js:638:20)

Linas Valiukas · Accepted Answer · 2018-07-26 06:11:52Z

0

The extension is unable to load an OpenSSL shared library at /opt/pgbin-build/pgbin/shared/osx_64/lib/libcrypto.1.0.0.dylib. Try fully reinstalling your PostgreSQL distribution or using one from Homebrew.

answered Jul 26, 2018 at 6:11

Linas Valiukas

1,4061 gold badge15 silver badges23 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

node.js db-migrate create extension issue

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related