02 - Install
Last updated
Last updated
In this module, we'll set up the Postgres database for our server using PG Admin and Sequelize.
We're going to be working with the database, as shown here:
Come up with a Postgres password right now. Make it unique. Don’t make it into a password that you use for anything else.
Please take the time to record this password somewhere safe. Resetting a Postgres password is not impossible, but is very challenging and, more importantly, very time consuming. Take the time to document this password. Several previous students have spent many hours attempting to reset their password. I use Letmein1234!. This will be for local use only, so there is no fear of someone else accessing your database using this password.
RECORD YOUR PASSWORD SOMEWHERE!!!
When the download is done, go through the install steps. NOTE: You should set the port to 5432 (this is the default port number. PLEASE DO NOT CHANGE IT!!).
After the download completes, choose PostgreSQL from the dropdown in Stack Builder.
Open up PG Admin 4.
Mac users should click on plug
Click Server, then click Postgres.
Log in with your memorable password.
Right click on "Database".
Choose "Create Database".
Name it "workoutlog".
You've just created your first database! We're finished with the setup, but if you have any problems with this, ask us and we’ll help. Before moving on, please make sure that others around you have been able to create a database.
Install postgres .
