Skip to content

Instantly share code, notes, and snippets.

@rifatdinc
Created February 9, 2022 21:13
Show Gist options
  • Save rifatdinc/2387237727db517fed422ba33473ab1f to your computer and use it in GitHub Desktop.
Save rifatdinc/2387237727db517fed422ba33473ab1f to your computer and use it in GitHub Desktop.
POSTGRESQL USERNAME PASSWORD DEFAULT SET
[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