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

0 vote115 views1 answer
MySQL - Enabling the Event Scheduler
SQL
0 vote130 views1 answer
Mysql Puede ser solamente un campo automatico y este debe ser definido como una clave
SQL
1 vote114 views1 answer
Sql query row number group by
SQL
0 vote109 views1 answer
Mariadb cast null to 0
SQL
4 votes117 views5 answers
Primary key
SQL
3 votes68 views4 answers
Mysql delete duplicate rows
SQL
1 vote110 views1 answer
Mysql get latest duplicate rows
SQL
-1 vote58 views1 answer
How to create script to connect to oracle database and run query
SQL
1 vote160 views1 answer
Alter constraint postgres
SQL
0 vote85 views0 answer
SQL