Check psql if is installed psql --version if you don't have installed then install from official page when installed make sure can see something like this
psql (PostgreSQL) 14.2 (Ubuntu 14.2-1.pgdg20.04+1+b1)
check status of psql sudo service postgresql status look like this
● postgresql.service - PostgreSQL RDBMS
Loaded: loaded (/lib/systemd/system/postgresql.service; enabled; vendor preset: enabled)
Active: active (exited) since Thu 2022-04-14 17:20:08 -04; 3s ago
Process: 38001 ExecStart=/bin/true (code=exited, status=0/SUCCESS)
Main PID: 38001 (code=exited, status=0/SUCCESS)
abr 14 17:20:08 alfredo systemd[1]: Starting PostgreSQL RDBMS...
abr 14 17:20:08 alfredo systemd[1]: Finished PostgreSQL RDBMS.
If service psql is inactive only need sudo service postgresql start
Run this command for create user
sudo -u postgres createuser testuser
# For crete db
sudo -u postgres createdb testdb
Now we make setting for nice work with that user and the database
First enter to psql
sudo -u postgres psql
For see all user list you can run \du
when see all user list we cannot see any roles even doesn't exist password for this user , we need add some privileges inside db (postgres)
ALTER USER testuser with encrypted password 'secret';
# If this command run success, message look like this
# ALTER ROLE
grant all privileges on database testdb to testuser;
# GRANT
when list again with \l the database has attach to new user
Top comments (0)