9

Postgresql creates a default user called postgres, so login as default user and create a new user sudo -i -u postgres createuser --interactive Then enter your linux username and select Yes for superuser option. Exit the postgre user by typing exit. With your user, create a new database by typing createdb mydb In the database, you can create your table ...


3

For Windows users: 1- Create a new user on SQL Shell: CREATE ROLE your_user_name LOGIN PASSWORD 'your_password' NOINHERIT CREATEDB; 2- Create a new database on SQL Shell: Close the SQL shell and open it again, enter the new username and password for the user you just created. To create a new database, write the following command: CREATE DATABASE mydb; ...


1

I am also having issues with logging into Adminer. There are also individuals with the same problem within this Reddit: https://www.reddit.com/r/cs50/comments/gjqnqy/adminer_login_session_expired_please_login_again/ And I also created a new post here: adminer.cs50.net giving "Session expired, please login again." error when attempting to login ...


1

1- Create a new user on SQL Shell: CREATE ROLE your_user_name LOGIN PASSWORD 'your_password' NOINHERIT CREATEDB; 2- Create a new database on SQL Shell: Close the SQL shell and open it again, enter the new username and password for the user you just created. To create a new database, write the following command: CREATE DATABASE mydb; You should connect to ...


1

the problem seems to be with the os module, I can run the code without any problem if I specify url='postgresql://localhost' in the code. I seem to struggle to get values of environment variables I set up. I use Anaconda - running the database and setting the envir var in Anaconda terminal + running the list.py code in Spyder. I tried multiple ways of ...


Only top voted, non community-wiki answers of a minimum length are eligible