15 minutes
Participants will be able to:
- Use PostgreSQL from the command line (
psql
) and, optionally, a GUI admin app
Previously we have installed Homebrew, if not follow the instruction on Homebrew site
Run the following two commands to make sure that Homebrew installation is healthy, and up to date:
brew doctor
brew update
brew install postgresql
Check the version of PostgreSQL using this command
psql --version
You can start PostgreSQL services with this command:
brew services start postgresql
To test that it works, we can create the default database:
createdb `whoami`
Note: If you get any error like this createdb: error: connection to server on socket "/tmp/.s.PGSQL.5432" failed: No such file or directory
try this command
rm -rf /usr/local/var/postgres
initdb /usr/local/var/postgres -E utf8
To stop PostgreSQL run
brew services stop postgres
To restart PostgreSQL
brew services restart postgres
psql postgres
You will see the following output
$ psql postgres
psql (14.1)
Type "help" for help.
postgres=#
Congratulation now you have successfully login to the postgres. Try some of the commands
Commands | Description |
---|---|
\du | to list all the users |
\l | to list all the databases |
CREATE DATABASE mydb; | to create a database. Here mydb is the name of the database |
\c mydb; | to connect to a database |
\d | to list all the tables inside a database |
\q | to exit or quit from psql |
Being a database, Postgres stores most of its settings in itself! So the config file isn't really useful for us.
Note: Some participants had issues last cohort with the data not syncing properly while creating tables using Postico. Please do not use it to create or modify your tables, think of it as a visual to see the tables you have.
Install: https://eggerapps.at/postico/
If you created a DB of your user, it should work out of the box if you specify localhost
to connect.
This is not recommended because it is too advanced and difficult to connect.
Passwords? with the default setup you shouldn't need a password.
- Commands - A list of PostgreSQL commands on a GitHub gist.