Basic Linux user and PostgreSQL setup commands
![Text "TECH" in RGB whit black background.](/media/images/tech_dark.width-900_vDyVZD3.webp)
Linux commands
User
Add new user
sudo adduser devuser
Sudo privileges
Add sudo privileges
adduser devuser sudo
Remove sudo privileges from user
sudo deluser devuser sudo
Change password on user[1]
sudo passwd devuser
Delete user [2]
userdel -r devuser
if error
sudo killall -u devuser
or
userdel -f devuser
PostgreSQL commands
Setup
Create database
sudo su - postgres
createdb devdb
Create database user
sudo su - postgres
createuser -P devuser
or [3]
sudo su - postgres
psql
CREATE USER devuser WITH PASSWORD 'devpassword';
\q
Grant privileges to database user
sudo su - postgres
psql
GRANT ALL PRIVILEGES ON DATABASE devdb TO devuser;
\q
Backup
sudo su - postgres
pg_dump --no-owner -x devdb > backup.psql
exit
Restore backup
sudo su - devuser
psql devdb < backup.psql