How To Create A Postgres Database Using pgAdmin - Training Video
Why Stack Overflow recommends it
Stack Overflow users link it when answering beginners who need to set up Postgres locally, create a database or fix role errors with the pgAdmin GUI.
Recommended by 3 people across 3 different months, 2012 to 2015.
What it is
A short EDB training video in which product manager Gary Carter shows first-time Postgres users how to create a database in pgAdmin. It also tours basic pgAdmin features such as entering data and building multi-table queries with the graphical query tool, without writing SQL.
What people said
Recommends Burhan Khalid · 2012-12 · Stack Overflow · on “How To Run Postgres locally”
First step, is to get Flask + Postgresql running locally, and the first step to do that is to install postgresql on your machine [LINK] . Next, you should install the python drivers for postgresql [LINK] . For Windows, you can use the windows installer for postgresql [LINK] and the windows installer for the python drivers [LINK] . Once you have finished the above two steps, you need to create a database [LINK] . For Windows, you can use the bundled pgadminIII tool. Here is a video [this video] that shows how to do just that. For example, here is how you create a database called the_database , and create a user called databaseuser with a password P@ssw0rd using the built-in tool psql : $ psql -d t
Recommends manu29.d · 2014-04 · Stack Overflow · on “PG::ConnectionBad FATAL: role "Myname" does not exist”
On Windows, I believe it is a little easier. Install postgresql and PGAdmin for your system. See this [LINK] Create a user named postgres and give it a password. You will be nicely prompted to do this. Then, when you want to create databases [this video] , just right click on your connection and choose New Database. The names of these databases should correspond to what is written in your database.yml Run rake db:migrate RAILS_ENV=development (development| test| production). These steps worked for me.
Recommends alebian · 2015-12 · Stack Overflow · on “myRailsApp - PostgreSQL FATAL error”
You don't have a role with that name created in the Postgres DBMS. If you are new, you probably should download Pgadmin ( [LINK] ), there you can configure your postgres database. When you open it you will see your servers and stuff, loof for the 'Login roles' part and create a new role that can create databases (That role needs to have the same user and password you chose on the configuration file) [this video]