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 vote348 views1 answer
Sql not equal multiple columns
SQL
2 votes338 views1 answer
While loop sql
SQL
1 vote388 views1 answer
Delete dublicate rows sql
SQL
3 votes346 views2 answers
How to list columns for particular tables in postgresql
SQL
2 votes381 views1 answer
Where clause for child record apex
SQL
25 votes416 views4 answers
Import mysql dump command line
SQL
2 votes396 views1 answer
Datefromparts mssql
SQL
4 votes324 views1 answer
Wilayah indonesia sql
SQL
0 vote356 views1 answer
Postgres can integer fields be negative
SQL
0 vote352 views2 answers
Nosqlbooster query other collection
SQL