How can I solve Postgresql SCRAM authentication problem?

by

For those on M1-Based macs who are currently seeing this issue in docker – there appears to a bug upstream in libpg that’s building against the wrong library version on ARM.

Until it’s fixed, a workaround is to (at a performance hit) is to just run it via rosetta.

export DOCKER_DEFAULT_PLATFORM=linux/amd64, and re-build your images.

You’ll get the latest version of libpq, and things should Just Work.

Ref: https://github.com/psycopg/psycopg2/issues/1360

More Related Contents:

  1. How to login and authenticate to Postgresql after a fresh install?
  2. Keep PostgreSQL from sometimes choosing a bad query plan
  3. Copying PostgreSQL database to another server
  4. How to handle authentication/authorization with users in a database?
  5. Primary keys with Apache Spark
  6. How can I put a database under git (version control)?
  7. Spring Security 3 database authentication with Hibernate
  8. How do IMMUTABLE, STABLE and VOLATILE keywords effect behaviour of function?
  9. Store query result in a variable using in PL/pgSQL
  10. Can I rollback a transaction I’ve already committed? (data loss)
  11. Kill a postgresql session/connection
  12. PostgreSQL: Drop PostgreSQL database through command line [closed]
  13. Do stored procedures run in database transaction in Postgres?
  14. Import SQL dump into PostgreSQL database
  15. how to use Blob datatype in Postgres
  16. Convert SQLITE SQL dump file to POSTGRESQL
  17. Is it better to use multiple databases with one schema each, or one database with multiple schemas? [closed]
  18. PostgreSQL Database Log Transaction
  19. Connect to a heroku database with pgadmin
  20. How do I automatically update a timestamp in PostgreSQL
  21. Starting and populating a Postgres container in Docker
  22. Adding a new value to an existing ENUM Type
  23. How can I import a .sql file into my Heroku postgres database?
  24. Backup/Restore a dockerized PostgreSQL database
  25. Difference between partition key, composite key and clustering key in Cassandra?
  26. How to get english language word database? [closed]
  27. How can I find MAX with relational algebra?
  28. SQL DataType – How to store a year?
  29. PostgreSQL nested INSERTs / WITHs for foreign key insertions
  30. Any example of a necessary nullable foreign key?

Leave a Comment