search

timgit / pg-boss

Queueing jobs in Postgres from Node.js like a boss
MIT License
2.13k stars 158 forks source link

pgcrypto still needed? #211

Closed DoReVo closed 3 years ago

DoReVo commented 3 years ago

Using the latest 5.08 version of pg-boss.

I successfully ran boss.start() without having pgcrypto installed as an extension. So do we still need the extension as mentioned in the documentation?

timgit commented 3 years ago

If this was the first time installing the schema, this line would fail if pgcrypto were not already installed in the target database.

DoReVo commented 3 years ago

Ah yes, somehow it didn't happened with my current database. But when i create a new database and try to start boss. It failed. So we still need it. Thanks.

noinkling commented 2 years ago

Note that as of Postgres 13, gen_random_uuid() is built-in: https://www.postgresql.org/docs/13/functions-uuid.html