how to install postgresql-contrib when using brew to install postgresql on OSX

[Mike M]

i'm getting the following error:

PG::SyntaxError: ERROR: syntax error at or near "PARALLEL"
LINE 12: -- Name: plpgsql; Type: EXTENSION; Schema: -; Owner: -

i think this is because I haven't installed postgresql-contrib -- can someone help me understand how to install this. i have installed postgresql on OSX using brew.

from what I can gather, postgresql-contrib, is a collection of modules or is it a specific module?

[Mike M]

i'm not sure if brew allows this, but through removing all versions of postgresql installed via brew -- it is easiest to just install the postgres.app which comes with all the needed modules

but this means any past users, roles and databases will be lost unless you figure out how to port them over