How to install pgcrypto extension on postgres13 on MacOS

Question

I'm using postgres13 and running a somewhat old ruby on rails project, it has a few migrations and one of the first lines on those migration files is: enable_extension "pgcrypto"

All the migrations with that fail.

After looking up online, most answers mention to download postgres-contrib package, which would in turn allow me to go into psql and create the extension.

I was only able to find that package for linux distributions. So I wonder if anyone can help me find a mac version, or some workaround.

I wonder also if I could solve this by installing an older version of postgresql that could come with this pre installed, but I'm not able to find that info anywhere. Any help appreciated.

Which postgres13 are you using? Postgres.app? Homebrew? Build from source? — Beartech, Apr 06 '23 at 05:31
It's not the app version, but I did not comment which one because I really don't remember how I installed it — Gabriel Oliveira, Apr 06 '23 at 11:53

score 2 · Accepted Answer · answered Apr 06 '23 at 05:55

2

Are you sure the extensions are not already there? Have you tried it install it with

CREATE EXTENSION pgcrypto;

To see if the module is available you can connect to your postgres DB and to the internal DB called postgres

\c postgres

then ask it what extensions are available:

select * from pg_available_extensions;

When I run this on my instance of Postgres.app running version 13 I get the entire list of extensions, with pgcrypto in there ready to be installed. You could use Postgres.app to do what you need, it's an excellent way to run multiple versions of postgresql on your Mac.

answered Apr 06 '23 at 05:55

Beartech

6,173
1
18
41

I'll give the postgres.app a try thanks – Gabriel Oliveira Apr 06 '23 at 11:54
This worked by installing the app version, then going to psql console and executing create extensions pgcrypto – Gabriel Oliveira Apr 06 '23 at 14:23

How to install pgcrypto extension on postgres13 on MacOS

1 Answers1