Installing PostgreSQL-12 on Ubuntu 20.4

preview_player
Показать описание
This video shows how to install PostgreSQL 12 on Ubuntu server 20.4 release. In this video, we also show how to connect to psql, create a user, create a database and also how to grant and revoke permissions from a user.

Рекомендации по теме
Комментарии
Автор

thank you! it was straightforward and easy to understand 👍
For me there were two hiccups but I think it was because I was using an Ubuntu Docker Container.
After executing `apt install postgresql postgresql-contrib`
the install was successful but it gave me two lines that I didn't see when you installed which were
`invoke-rc.d: could not determine current runlevel` and
`invoke-rc.d: policy-rc.d denied execution of start.`

the other hiccup was when I tried `psql` as user `postgres`.
it said it "could not connect to server"
I had to enter `service postgresql start` first and then `psql` worked 👍

thank you again sir! 🎩

mataridev
Автор

Nice, but what about creating a database cluster that is written on Postgres Documentation? It looks like necessary preparation of environment setup after installing Postgres.

SeargeB