I am trying to create a postgresql database via sqlalchemy in pycharm (running python 3.6) but have trouble connecting / creating the database.
I initially started with sqlalchemy tutorial:
from sqlalchemy import create_table
engine =create_engine("postgresql+psycopg2://scott:tiger@localhost/test")
connection = engine.connect()
connection.close()
But it print's the error: could not connect to server: Connection refused (0x0000274D/10061)
Is the server running on host "localhost" (127.0.0.1) and accepting
TCP/IP connections on port 5432?
How should I be opening up the port, or pointing it to the localhost?
Is there any specific thing that I need to do to create the database before i run create_engine?
I've also been searching online and found that perhaps I should be using psycopg2 to create the database, but I don't understand how this is to be done.
What I would like is to create a postgresql database on my desktop, in a specific folder.