/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

6 votes310 views3 answers
How to install java 11 jdk on ubuntu 20.04
Shell/Bash
0 vote273 views1 answer
How to set global github username and password in git
Shell/Bash
0 vote247 views1 answer
How to open sh file
Shell/Bash
0 vote315 views1 answer
Powershell copy folder to remote computer
Shell/Bash
0 vote278 views1 answer
Bcrypt fails during docker compose
Shell/Bash
1 vote291 views1 answer
Yarn run ios device
Shell/Bash
0 vote294 views1 answer
Invokemethodonnull powershell try catch
Shell/Bash
2 votes279 views1 answer
Flutter build aab
Shell/Bash
1 vote276 views1 answer
Open gui of git repo
Shell/Bash
0 vote305 views1 answer
Download chrome on ubuntu 20.04 unsupported file
Shell/Bash

Share