Skip to Content
Meniu
Trebuie să fiți înregistrat pentru a interacționa cu comunitatea.
Această întrebare a fost marcată
2 Răspunsuri
27368 Vizualizări

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

 

Imagine profil
Abandonează

try to create new database in pgadmin if know that.

Cel mai bun răspuns

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

 

 

 

Imagine profil
Abandonează
Autor

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

Autor

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

Autor

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.

Cel mai bun răspuns

Try this command

ALTER USER postgres PASSWORD 'newpassword';

Imagine profil
Abandonează