Password authentication failed for user "dbadmin"

Questions
1

Describe the problem/error/question

n8n is deployed to ECS. The variables are set through a shell script that exports them.
The deploiment works norma. up untill n8n loses acces to the database after a while (usually a week).

export DB_TYPE=postgresdb
export DB_POSTGRESDB_DATABASE=n8n
export DB_POSTGRESDB_HOST=$RDS_ENDPOINT
export DB_POSTGRESDB_PORT=$RDS_PORT
export DB_POSTGRESDB_USER=$RDS_USERNAME
export DB_POSTGRESDB_PASSWORD=$RDS_PASSWORD
export DB_POSTGRESDB_SCHEMA=n8n

What is the error message (if any)?

password authentication failed for user “dbadmin”

Information on your n8n setup

  • n8n version: 1.74.1
  • Database (default: SQLite): postgresdb
  • n8n EXECUTIONS_PROCESS setting (default: own, main):
  • Running n8n via (Docker, npm, n8n cloud, desktop app): docker
  • Operating system: linux
2

Consider using AWS secret manager, insted of jut variable,

for now this should fix:

# Add connection pool settings
export DB_POSTGRESDB_POOL_MIN=2
export DB_POSTGRESDB_POOL_MAX=10

# Add connection timeout settings
export DB_POSTGRESDB_CONNECTION_TIMEOUT=60000

# Add keepalive settings
export DB_POSTGRESDB_KEEPALIVE_INTERVAL=30000