Error in database connection: Database "dbname" does not exist

Question

I have created a python file app.py and included the code to connect to a db I created in postgresql as follows: -

import psycopg2 conn = psycopg2.connect( user='postgres', password='1234', host='localhost', port='5432', database='bubbleformation' ) cursor = conn.sursor() cursor.execute('SELECT * FROM bubbleformation') for row in cursor: print(row) conn.close()

This was as instructed in this medium article

However, when I try to execute this python file in the terminal, I get the below error: -

Traceback (most recent call last): File "app.py", line 8, in port='5432' File "/usr/lib/python2.7/dist-packages/psycopg2/init.py", line 130, in connect conn = _connect(dsn, connection_factory=connection_factory, **kwasync) psycopg2.OperationalError: FATAL: database "bubbleformation" does not exist

I have created a table named "bubbleformation" and it can be viewed in the psql mode through the terminal.

Could anyone please help me understand what should be done? I tried changing the password, and user privileges, but none of them worked for my error.

did you check if database exist? List the databases psql -l and list the tables in bubbleformation psql -d bubbleformation. — arunp9294
– arunp9294, Commented Oct 12, 2019 at 15:09

ipaleka · Accepted Answer · 2019-10-12 15:06:53Z

You should create both database and table with the same name "bubbleformation". You've probably created that table in postgres database.

Enter psql as postgres user and call CREATE DATABASE bubbleformation;, then connect to it with \connect bubbleformation and then create your table (something like CREATE TABLE bubbleformation (id int, name text);).

Thank you! You are right, "bubbleformation" was the name of the table. Thank you very much!

Thom Brown · Accepted Answer · 2019-10-12 15:24:26Z

The error is about there not being a database named "bubbleformation", so when you connect to the database in the terminal, whichever database that is is the one you need to specify in the database parameter. When you connect to the database in the terminal, type:

SELECT current_database();

If it is indeed a database named "bubbleformation" then is must be a different cluster you are connecting to, and therefore a different port.

Disclosure: I am an EnterpriseDB (EDB) employee.

Thank you very much for the answer! Changing the database name solved my problem.

Aritra Chatterjee · Accepted Answer · 2020-02-24 04:38:20Z

Its due to environment error. I was loading the credentials from the .env file. But i mistakenly gave a wrong path.

 project_folder = os.path.expanduser('~/scraping') instead of project_folder = os.path.expanduser('~/find_my_nearest_store') load_dotenv(os.path.join(project_folder, '.env'))

Hence the Error.

Collectives™ on Stack Overflow

Error in database connection: Database "dbname" does not exist

3 Answers 3

1 Comment

1 Comment

Comments

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

1 Comment

1 Comment

Comments

Related