We need pg to use PostgreSQL with NodeJS. Check out the documentation: pg npm
Next let's create a database for our application.
$ psql candy=# CREATE DATABASE node_cms;
Now, connect to the database you just created.
candy=# \c node_cms