Setup and Introduction to SQL Fundamentals

After installing postgres on Ubuntu 18 (via WSL) using official documentation https://www.postgresql.org/download/linux/ubuntu/, I run into multiple issues. This comment might help someone who also wants to install postgres on WSL. First issue was about how to run server, because psql was complaining. In order to resolve that I had to do following:

• sudo chown postgres /var/log/postgresql
• sudo ln -s /etc/postgresql/10/main/postgresql.conf /var/lib/postgresql/10/main/postgresql.conf
• sudo ln -s /etc/postgresql/10/main/conf.d /var/lib/postgresql/10/main/conf.d
• sudo -u postgres /usr/lib/postgresql/10/bin/pg_ctl -D /var/lib/postgresql/10/main -l /var/log/postgresql/logfile start

After that, in order to run psql I used following command: sudo -u postgres psql postgres

I ran into this issue.

$ psql postgres
psql: could not connect to server: No such file or directory
	Is the server running locally and accepting
	connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

I did this to get it to work.

$ brew services start postgresql
==> Tapping homebrew/services
Cloning into '/usr/local/Homebrew/Library/Taps/homebrew/homebrew-services'...
remote: Enumerating objects: 14, done.
remote: Counting objects: 100% (14/14), done.
remote: Compressing objects: 100% (9/9), done.
remote: Total 14 (delta 0), reused 8 (delta 0), pack-reused 0
Unpacking objects: 100% (14/14), done.
Tapped 1 command (43 files, 59.6KB).
==> Successfully started `postgresql` (label: homebrew.mxcl.postgresql)

$ psql postgres
psql (11.5)
Type "help" for help.

postgres=#

Do you have to create a database first ?

Do you have to create a database first ?

Hi @blackoperat, if you're talking about this lesson all you would have to do ins download and install postgres everything else will walked through in the lessons. Let me know if that helps!