/Shell/Bash/Postgres create admin user with password

Postgres create admin user with password

Create new user in postgres

CREATE USER visualscrapy WITH PASSWORD '123456';
# it will create the new user in postgres

1

Postgres create admin user with password

sudo -u postgres createuser -s -i -d -r -l -w <<username>>
sudo -u postgres psql -c "ALTER ROLE <<username>> WITH PASSWORD '<<password>>';"

0

Source: stackoverflow.com

Similar codes

0 vote170 views1 answer
Uninstall flutter from snap
Shell/Bash
1 vote184 views2 answers
No such remote 'upstream'
Shell/Bash
0 vote180 views2 answers
Sed print from match to end of file
Shell/Bash
1 vote184 views1 answer
Git force rebase abort
Shell/Bash
0 vote180 views1 answer
View rpm info
Shell/Bash
0 vote180 views1 answer
Aws cli has no installation package in ubuntu server 20.04 how to solve
Shell/Bash
0 vote220 views1 answer
Linux how to run executable in background $
Shell/Bash
0 vote178 views1 answer
How to launch synaptic package manager from terminal in ubuntu
Shell/Bash
21 votes178 views5 answers
Bash get current path
Shell/Bash
0 vote173 views1 answer
Download from web linux bash
Shell/Bash

Share