Konga: Can't start konga with postgres 12-alpine

[timpamungkas]

Hi, I'm trying to start konga with postgres 12 (docker-based) as database.
However, it cannot started.
The docker logs show this error

Postgres 11 works fine

 debug: Preparing database...
konga-prepare     | Using postgres DB Adapter.
konga-prepare     | Database exists. Continue...
konga-prepare     | error: A hook (`orm`) failed to load!
konga-prepare     | error: Failed to prepare database: error: column r.consrc does not exist
konga-prepare     |     at Connection.parseE (/app/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:539:11)
konga-prepare     |     at Connection.parseMessage (/app/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:366:17)
konga-prepare     |     at Socket.<anonymous> (/app/node_modules/sails-postgresql/node_modules/pg/lib/connection.js:105:22)
konga-prepare     |     at Socket.emit (events.js:198:13)
konga-prepare     |     at Socket.EventEmitter.emit (domain.js:448:20)
konga-prepare     |     at addChunk (_stream_readable.js:288:12)
konga-prepare     |     at readableAddChunk (_stream_readable.js:269:11)
konga-prepare     |     at Socket.Readable.push (_stream_readable.js:224:10)
konga-prepare     |     at TCP.onStreamRead [as onread] (internal/stream_base_commons.js:94:17)

[andrerfneves]

I can confirm this happens on PostgreSQL 12+ on macOS systems.

[pantsel]

Postgres 12+ is not supported by the underling pg driver.

[phlegx]

@pantsel Is this still the case or is it supported in the meanwhile?

Getting the same error as @timpamungkas, so I assume, that it is probably the case.
Are there plans to support postgres 12 at some point?

[phlegx]

@pantsel Hi there! It's me again. Can we support higher Postgres versions as well?

[lwx2615]

I used node ./bin/konga.js prepare --adapter postgres --uri postgresql://192.168.2.22:5432/konga,it always error: role "root" not exist! Then I crate the root in psql,the error: A hook (orm) failed to load! I just installed the PostgreSQL 12 ! Any news to support it?

[edijsdrezovs]

Waiting for PostgreSQL 12 support 👍