/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

4 votes140 views1 answer
How to start venv
Shell/Bash
0 vote159 views1 answer
How to install multible package in linux one line of code
Shell/Bash
6 votes168 views2 answers
Git get last commit id
Shell/Bash
58 votes210 views6 answers
Install pip3
Shell/Bash
0 vote160 views1 answer
Nearest location using php
Shell/Bash
1 vote155 views1 answer
Bashrc termina,
Shell/Bash
0 vote145 views1 answer
Ubuntu search for file whole hard drive
Shell/Bash
1 vote153 views1 answer
Svn log last 10
Shell/Bash
0 vote153 views1 answer
Drupal update config install
Shell/Bash
1 vote146 views2 answers
Docker machine ip
Shell/Bash

Share