Error 1014 - Database does not exist

Last updated on Nov 16, 2022
Error Code 1014
Error Message Text(s) - Database does not exist. Please check the Database Name value provided.

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

Refer to the following table for the list of key updates made to this page:

Date Release Description of Change
Sep-30-2022 NA New document.

Tell us what went wrong