Useradd postgres

Psql create user

# https://www.postgresql.org/docs/8.0/sql-createuser.html
CREATE USER <username> WITH PASSWORD '<password>' VALID UNTIL '<date here>';

Useradd postgres

sudo -u postgres psqlpostgres=# create database mydb;postgres=# create user myuser with encrypted password 'mypass';postgres=# grant all privileges on database mydb to myuser;

Source: medium.com

Similar codes

1 vote147 views1 answer
Where database run
SQL
1 vote147 views1 answer
Caused by: java.lang.IllegalStateException: Cannot load driver class: com.mysql.jdbc.Driver
SQL
0 vote145 views1 answer
Kill a pid redshift
SQL
0 vote145 views1 answer
What is delimiter in mysql
SQL
1 vote142 views1 answer
Oracle select first result
SQL
2 votes141 views1 answer
Alter table add column and foreign key mysql
SQL
4 votes108 views1 answer
Oracle sleep
SQL
34 votes188 views6 answers
Alter table add foreign key mysql
SQL
1 vote138 views1 answer
Order by oracle
SQL
4 votes134 views1 answer
Mysql insert from local csv
SQL