콘텐츠로 건너뛰기
메뉴
커뮤니티에 참여하려면 회원 가입을 하시기 바랍니다.
신고된 질문입니다
2 답글
27541 화면

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';

아바타
취소