Created
February 9, 2022 21:13
-
-
Save rifatdinc/2387237727db517fed422ba33473ab1f to your computer and use it in GitHub Desktop.
POSTGRESQL USERNAME PASSWORD DEFAULT SET
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
[LINUX] | |
might work for windows too | |
After installing postgres follow following steps in order to setup password for default system account of Linux execute following in terminal: | |
user:~$ sudo -i -u postgres | |
postgres@user:~$ psql | |
after executing above two commands you will get into postgres shell | |
Execute this query in postgres shell: | |
postgres=# ALTER USER postgres PASSWORD 'mynewpassword'; | |
your new password is 'mynewpassword' without quotes and now you can connect with external GUI tools like DBeaver |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment