...
If you want to manage postgresql outside of the command line, you must change the default password in postgresql.
The first step, is to step into launch the postgresql shell launching the program psql as the user postgres.
Code Block | ||
---|---|---|
| ||
sudo -u postgres psql postgres # |
The command is confusing so here is a break down,
Code Block | ||
---|---|---|
| ||
sudo -u postgres makes# Run the command as the user postgres. psql run as the postgres user # The program to launch the postgresql which due to the sudo will launch with the user postgres. postres # This is a reference to the name of the database to load (not the user). |
Here is what it looks like once you are in,
...