Graphql-engine: Error in log "pgcrytpo"

[pomazanbohdan]

[pomazanbohdan]

I like this newbie confused

[shahidhk]

@Pomazan-Bogdan Can you execute this SQL on the database?

psql <database-url> -c 'CREATE EXTENSION pgcrypto;'

Hasura needs this extension to handle UUID types.

If you're connecting as a non-super user, checkout this guide to see what are the required permissions etc: https://docs.hasura.io/1.0/graphql/manual/deployment/postgres-permissions.html

[pomazanbohdan]

pgcryTPo

see screenshot

[0x777]

The help message has the typo. We'll fix this. However if you create the extension as Shahidh has suggested/or start graphql-engine with a superuser, you shouldn't be seeing this error.

[ecthiender]

@Pomazan-Bogdan it looks this error will only occur if the postgres instance does not have the pgcrypto extension available. Usually, pgcrypto extension is available by default.

Would you comment on what postgres distribution you are using (such that the pgcrypto extension is not available by default)?

[pomazanbohdan]

I've put the expansion through the addition of a bundle of contributions.
There are no problems with this

The problem was just a typo in the log, because I went to google not what I needed, and after 5 minutes I understood that something was wrong.

[ecthiender]

Absolutely, understand the issue with the typo.

Just wanted to know how did you install postgres. Or what distribution you
are using.

On Mon, Jan 7, 2019 at 9:14 PM Pomazan Bogdan [e-mail]
wrote:

I've put the expansion through the addition of a bundle of contributions.
There are no problems with this

The problem was simply a typo in the log, because I did not want to gobble
up what I needed, and after 5 minutes I realized that something was wrong.

—
You are receiving this because you were assigned.
Reply to this email directly, view it on GitHub
https://github.com/hasura/graphql-engine/issues/1322#issuecomment-451977491,
or mute the thread
https://github.com/notifications/unsubscribe-auth/AAlnwyWBkiZss4fylKw53-jorB9-gXSBks5vA2tTgaJpZM4ZydGC
.

[pomazanbohdan]

centos 7
add repo postgress 11
just in all the installation instructions did not mention the -contrib package