'Postgresql setup

I'm learning Ruby and Postgresql and I'm trying to run a db project where I'm running this file to get started:

#!/usr/bin/env sh

dropdb sqlzoo
createdb sqlzoo
psql sqlzoo < data/create_tables.sql

But I get this output in the console:

dropdb: could not connect to database template1: FATAL:  role "my_name" does not exist
createdb: could not connect to database template1: FATAL:  role "my_name" does not exist
psql: FATAL:  role "my_name" does not exist

When logging into PSQL it shows that user <my_name> is a Superuser. The template1 db is there by default. How can I proceed here to get this setup working?

rubypostgresql


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source

Related Questions