[FIXED] Laravel Sail: FATAL: password authentication failed for user "sail"

Issue

I created a laravel sail project with PostgreSQL then I tried to connect with the server on 3rd party software (TablePlus & Navicat) I got this error message

FATAL:  password authentication failed for user "sail"

This is my docker-compose.yml

    pgsql:
        image: 'postgres:13'
        ports:
            - '${FORWARD_DB_PORT:-5432}:5432'
        environment:
            PGPASSWORD: '${DB_PASSWORD:-secret}'
            POSTGRES_DB: '${DB_DATABASE}'
            POSTGRES_USER: '${DB_USERNAME}'
            POSTGRES_PASSWORD: '${DB_PASSWORD:-secret}'
        volumes:
            - 'sailpgsql:/var/lib/postgresql/data'
        networks:
            - sail
        healthcheck:
          test: ["CMD", "pg_isready", "-q", "-d", "${DB_DATABASE}", "-U", "${DB_USERNAME}"]
          retries: 3
          timeout: 5s

And this is my env

DB_CONNECTION=pgsql
DB_HOST=pgsql
DB_PORT=5432
DB_DATABASE=laravel
DB_USERNAME=sail
DB_PASSWORD=password

This is a fresh install I changed nothing. It's working with MySQL, am I missing something? thank you..

Solution

Turns out port 5432 is already used by another pgsql service on my windows so I just change FORWARD_DB_PORT in my env. silly me

Answered By - Heaven Aldrico