跳至内容
菜单
此问题已终结
2 回复
27379 查看

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

 

形象
丢弃

try to create new database in pgadmin if know that.

最佳答案

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

 

 

 

形象
丢弃
编写者

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

编写者

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

编写者

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.

最佳答案

Try this command

ALTER USER postgres PASSWORD 'newpassword';

形象
丢弃