/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

0 vote250 views1 answer
How to calculate nearest location using longitude and latitude
Shell/Bash
0 vote237 views1 answer
Ubuntu mate 20.04 videodev module not working
Shell/Bash
0 vote221 views1 answer
How to search the memory for the address of bin/sh
Shell/Bash
1 vote253 views1 answer
Wmv to mp4 ffmpeg
Shell/Bash
0 vote237 views1 answer
How run flutter project from git
Shell/Bash
0 vote250 views3 answers
Bash printf format
Shell/Bash
4 votes235 views5 answers
Install docker on centos
Shell/Bash
0 vote235 views1 answer
Rancher 2 on ubuntu 20.04
Shell/Bash
0 vote256 views1 answer
Install-nodejs-and-npm
Shell/Bash
8 votes240 views1 answer
Check gpu free memory linux
Shell/Bash

Share