/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

2 votes138 views1 answer
Search by message git
Shell/Bash
0 vote141 views1 answer
How to boot from grub rescue
Shell/Bash
-1 vote152 views1 answer
Apt-get install
Shell/Bash
0 vote137 views1 answer
Command to fix frozen shell
Shell/Bash
0 vote129 views1 answer
Default: Box 'hashicorp/bionic64' could not be found. Attempting to find and install
Shell/Bash
1 vote140 views2 answers
How to install pipenv on mac
Shell/Bash
6 votes130 views1 answer
Centos copy files ssh
Shell/Bash
-1 vote135 views2 answers
Ngx-bootstrap npm
Shell/Bash
0 vote208 views1 answer
Pm2 don't have have synchronised list
Shell/Bash
0 vote129 views1 answer
How to install image app in linux using terminal
Shell/Bash

Share