/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

1 vote108 views1 answer
Wpa passphrase for raspberry pi
Shell/Bash
2 votes114 views3 answers
Crt secure no warnings
Shell/Bash
2 votes116 views1 answer
Could not connect to development server
Shell/Bash
5 votes126 views6 answers
Git stash one file
Shell/Bash
4 votes124 views2 answers
List all node versions mac
Shell/Bash
10 votes120 views2 answers
Install flutter sdk
Shell/Bash
5 votes123 views3 answers
Rename branch to main
Shell/Bash
4 votes130 views5 answers
Find in linux
Shell/Bash
1 vote68 views1 answer
React-slick typescript
Shell/Bash
3 votes121 views1 answer
Unix if directory
Shell/Bash

Share