I installed PostgreSQL on my Ubuntu using "apt-get". I've been using "sudo" to perform operations (actually following a tutorial), but now I want to administer the DBMS with a client that asks me for the admin password "postgres".
How do I set this password?
To change the password for the postgres user, type the command:
$ sudo passwd postgres
After executing the command the following messages will appear:
Digite a nova senha UNIX:
Redigite a nova senha UNIX:
Enter your password and retype it later. After that, we will log in with the postgres user.
$ su postgres
The password that will be required is the same as the one we just changed.
Now let's change the password to connect to the bank.
This command is for version 7 or higher:
$ psql -c "ALTER USER postgres WITH PASSWORD 'nova_senha'" -d template1
Where nova_senha will be the password you want.
Source: vivaolinux .
Access the Postgres administration database with this command:
sudo -u postgres psql postgres
Set the admin user password using:
\password postgres
After entering and confirming the password use the shortcut "Crtl + D" to end the bank administration.