Unit 4 - Postgres Install 679bfdcdcf8f429eac120f5a24b6f34a.md

Unit 4 - Postgres Install

Installing Postgres (Mac)

1. Run the command brew install postgres
2. Run brew tap homebrew/services to install brew services.
3. Then run brew services start postgresql to start postgres as a background service
4. To stop postgres manually, run brew services stop postgresql. You can also use brew services to restart Postgres brew services restart postgresql

Installing Postgres (Ubuntu + WSL)

1. Follow instructions found here

Testing Postgres Connection

To test your postgres connection we will be using the psql command.

psql postgres

Your output should look similar to this

In the psql terminal you will use the following command

\l

This will display all available tables

Want to make it pretty? 💅

If you want a customized output for your psql terminal you can do the following steps: }

1. In your home directory create a .psqlrc file

touch .psqlrc

1. modify the file with code to include the following:

--\\set PROMPT1 '%[%033[1m%]%M %n@%/%R%[%033[0m%]%# '

\set PROMPT1 '\n%[%033[1;31;40m%] ➤ %[%033[32m%]%M %[%033[36m%]%n%[%033[34m%]@%[%033[36m%]%[%033[33m%]%/ %[%033[K%]%[%033[0m%]\n\n%[%033[1;33m%]%#%[%033[0m%] '

\set PROMPT2 '%[%033[1;33m%]% > %[%033[0m%]'

\x on

-- By default, NULL displays as an empty space. Is it actually an empty
-- string, or is it null? This makes that distinction visible.
\pset null '[NULL]'
-- Use table format (with headers across the top) by default, but switch to
-- expanded table format when there's a lot of data, which makes it much
-- easier to read.
\x auto
-- Verbose error reports.
\set VERBOSITY verbose
-- Use a separate history file per-database.
\set HISTFILE ~/.psql_history- :DBNAME
-- If a command is run more than once in a row, only store it once in the
-- history.
\set HISTCONTROL ignoredups
-- Autocomplete keywords (like SELECT) in upper-case, even if you started
-- typing them in lower case.
\set COMP_KEYWORD_CASE upper