/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 votes158 views1 answer
Almofire pod install
Shell/Bash
0 vote154 views1 answer
Run shell script remotely using ssh
Shell/Bash
20 votes149 views4 answers
Increment variable bash
Shell/Bash
0 vote201 views2 answers
Install minikube Chocolatey
Shell/Bash
0 vote169 views1 answer
Import db drush
Shell/Bash
2 votes171 views1 answer
Ubuntu "Read-only filesystem"
Shell/Bash
1 vote286 views1 answer
How to Rename or Move files in GIT
Shell/Bash
0 vote160 views4 answers
Storage/logs/laravel.log" could not be opened: failed to open stream: Permission denied
Shell/Bash
0 vote167 views1 answer
Ubuntu read only file system ntfs partition
Shell/Bash
0 vote176 views1 answer
Docker-compose-to-always-re-create-containers-from-fresh-images
Shell/Bash

Share