Error 1014 - Database does not exist

Error Summary

• Hevo is unable to find the database provided by the user.

Potential Causes

• The database name is either incorrect or not provided.

Suggested Action(s)

• Verify that the Database Name entered in the Configure your PostgreSQL Destination page is correct.
  To do this:

  1. Log in to the PostgreSQL server with your SQL client, such as psql, using the Database User that you entered in the Configure your PostgreSQL Destination page.

  2. Enter the following command to display the list of your database names and to check whether the database name you provided is available:

     SELECT EXISTS (
     
         SELECT datname FROM pg_database
     
         where datname = '<database_name>'
     
       )
     

     Note: Replace the placeholder values in the commands above with your own. For example, <database_name> with school.

• Verify that the Database User entered in the Configure your PostgreSQL Destination page has access to the database.

• Invite another team member with the required privileges to set up the Pipeline. Read Inviting and Moderating Team Members.

Revision History