Botpress 12_2_0 Postgres Module Load Error

Hey Guys,

I am noticing when I try to switch botpress v12_2_0 from sqllite to postgres I am getting the following errors on server start.

OS: RHEL 7
Botpress: 12_2_0
Postgres: 9.2.24

12:35:13.201 ModuleLoader Error in module “channel-web” onServerStarted [error, create table “web_messages” (“id” varchar(255), “conversationId” integer, “incomingEventId” varchar(255), “userId” varchar(255), “message_type” varchar(255), “message_text” text, “message_raw” jsonb, “message_data” jsonb, “payload” jsonb, “full_name” varchar(255), “avatar_url” varchar(255), “sent_on” timestamptz) - type “jsonb” does not exist]
12:35:13.308 ModuleLoader Error in module “hitl” onServerStarted [error, create table “hitl_messages” (“id” serial primary key, “session_id” integer, “type” varchar(255), “source” varchar(255), “text” varchar(640), “raw_message” jsonb, “direction” text check (“direction” in (‘in’, ‘out’)), “ts” timestamptz) - type “jsonb” does not exist]
12:35:14.015 Server Loaded 11 modules

If we move back to sql lite we have no issues. Only when moving from sql lite to postgres. Also, if we remove the sql lite files it still fails when using postgres at startup.

Only postgres 9.5 and up is supported.
That probably explains the error about jsonb.

1 Like