Hello all,

I am trying to deploy redash using setup script I downloaded from this repo…

Getting this error

sqlalchemy.exc.OperationalError: (psycopg2.OperationalError) FATAL:  password authentication failed for user "postgres"
 (Background on this error at: http://sqlalche.me/e/e3q8)

Added these lines in ./data/docker-compose.yml

postgres:
    image: postgres:9.6-alpine
    env_file: /opt/redash/env
    volumes:
      - /opt/redash/postgres-data:/var/lib/postgresql/data
    restart: always
    environment:
      POSTGRES_HOST_AUTH_METHOD: "trust"

Still gives the same issue.

Additionally, I want to use the redash/redash:9.0.0-beta.b49509 image for my purpose.

Even on changing ./data/docker-compose.yml

version: "2"
x-redash-service: &redash-service
  image: redash/redash:9.0.0-beta.b49509

It still pulls the 8.x version image

Please let me know…

  1. How can I update the image of redash from docker-compose.yml
  2. How to resolve the postgres authentication error

Thank you :blush:

1 Like