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

13 votes224 views2 answers
Oracle all source
SQL
3 votes261 views1 answer
Sql datetime as date
SQL
0 vote299 views1 answer
Create user faunadb
SQL
0 vote271 views2 answers
Sql use not in
SQL
0 vote284 views1 answer
Illuminate\Database\QueryException SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client (SQL: select * from information_schema.tables where table_schema = blog and table_name = migrations and table_type = 'BASE TABL
SQL
0 vote271 views1 answer
Mysql default uuid
SQL
4 votes284 views4 answers
Rollback in sql
SQL
2 votes305 views1 answer
Create mysql user on all hosts
SQL
4 votes261 views1 answer
Mysql ip address
SQL
0 vote403 views1 answer
Sql developer export connections
SQL