Skip to Content
Menu
This question has been flagged
2 Replies
27308 Views

postgres@mycomapny-erp:/home/mycomapny$ sudo adduser --system --home=/opt/openerp --group odooo8
[sudo] password for postgres:
Sorry, try again.
[sudo] password for postgres:
Sorry, try again.
[sudo] password for postgres:

 

How to findout password --------need help

 

Avatar
Discard

try to create new database in pgadmin if know that.

Best Answer

You have to change the password of postgres user

Step 1: Open Terminal - Ctrl + Alt + T

Step 2: Type su postgres

Note: If you don’t remember the postgres (ubuntu user) password then use the command ‘sudo passwd postgres

Stept 3: Type ‘psql’ and enter

Step 4: Use the following command to change the posgres user password

alter user postgres with password ‘newpassword’;

Step 5: ‘\q’ is used to exit psql

 

EDIT------------------------------

 

I want to change root post gres password not user so i cant login same issue

 

 

 

Avatar
Discard
Author

I want to change root post gres password not user so i cant login same issue

I already told you change the password of postgres. Not to change the user.

alter user postgres with password ‘newpassword’;

use the above command

Author

siroco@siroco-erp:~$ su postgres Password: what password i can type in below line thats my problem k

Author

postgres@siroco-erp:/opt/openerp$ sudo wget http://gdata-python-client.googlecode.com/files/gdata-2.0.17.tar.gz [sudo] password for postgres: postgres is not in the sudoers file. This incident will be reported.

Actually you forgot the postgres password.

So that you have to change the password of postgres first. You can use the above 5 steps.

postgres user is not a sudo user, so its shows the above error. If you wan that first you have to set postgres as sudouser. Then run the above command.

sudo adduser sudo to add sudo user use this command.

Best Answer

Try this command

ALTER USER postgres PASSWORD 'newpassword';

Avatar
Discard