Couch2pg DB Sync Error

Technical Support
1

Hi,
I’m using the latest version of couch2pg and I keep getting the following error
Thank you.
Erick

/home/cht/cht-couch2pg/node_modules/couch2pg/node_modules/postgrator/node_modules/pg/lib/connection.js:426
throw new Error(“Unknown authenticationOk message type” + util.inspect(msg));
^

Error: Unknown authenticationOk message typeMessage { name: ‘authenticationOk’, length: 23 }
at Connection.parseR (/home/cht/cht-couch2pg/node_modules/couch2pg/node_modules/postgrator/node_modules/pg/lib/connection.js:426:9)
at Connection.parseMessage (/home/cht/cht-couch2pg/node_modules/couch2pg/node_modules/postgrator/node_modules/pg/lib/connection.js:345:17)
at Socket. (/home/cht/cht-couch2pg/node_modules/couch2pg/node_modules/postgrator/node_modules/pg/lib/connection.js:105:22)
at Socket.emit (events.js:314:20)
at addChunk (_stream_readable.js:297:12)
at readableAddChunk (_stream_readable.js:272:9)
at Socket.Readable.push (_stream_readable.js:213:10)
at TCP.onStreamRead (internal/stream_base_commons.js:188:23)

2

This was caused by an error in the configuration of my Postgres DB Server .
This is solved by Changing the password_encryption parameter in postgressql.conf

Edit postgresql.conf and change the parameter to

password_encryption = md5

3 Likes
3

Hey @ewafula, what version of postgresql are you running. Asking because we had the same issue documented, but with version 14. If on a different version and running into the same, it is worth updating the known issue.

4

I’m running ver. 14.
Thank you