Skip to main content

Troubleshoot `password authentication failed` in PostgreSQL exports

Fix a PostgreSQL export that fails because PostgreSQL rejects the username or password.

Problem summary

PostgreSQL rejects the username or password in your export's connection, so the export can't sign in to the database.

​

Error message or symptoms

The export fails with an error that contains:

​

password authentication failed for user

​

When does this occur

  • The username or password in the export's connection is wrong, or the password changed.

  • You use the Supabase Session pooler without your project reference in the username.

​

Root cause

The database user and password in the connection don't match a user in your PostgreSQL database.

​

Solution

  1. If you changed the password, update it in the export's connection. Otherwise, check the username and password of the database user you created for Funnel.

    ​

  2. For the Supabase Session pooler, add your project reference to the username, for example funnel_export.<project-ref> instead of funnel_export.

    ​

  3. Run the export again.

Did this answer your question?