x

Basic Linux user and PostgreSQL setup commands

27 Aug 2022 / Oscar F
tech

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
Twitter logo black Facebook “f” logo black Reddit logo black LinkedIn logo black Email icon black