Odoo Help

Welcome!

This community is for beginners and experts willing to share their Odoo knowledge. It's not a forum to discuss ideas, but a knowledge base of questions and their answers.

-1

How to find out postgres sql password ----when i install odoo8 it i cant enter password it shows error

By
Odoo
on 7/10/14, 1:27 AM 5,955 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

 

try to create new database in pgadmin if know that.

Allen Walker
on 7/10/14, 3:15 AM
2

Remya

--Remya--
5813
| 7 8 8
Thiruvananthapuram, India
--Remya--

Working as an Senior ODOO developer. http://in.linkedin.com/pub/remya-r/69/a23/298

Remya
On 7/10/14, 2:18 AM

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

Odoo
on 7/10/14, 2:52 AM

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

Remya
on 7/10/14, 3:04 AM

alter user postgres with password ‘newpassword’;

Remya
on 7/10/14, 3:06 AM

use the above command

Remya
on 7/10/14, 3:06 AM

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

Odoo
on 7/10/14, 3:17 AM

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.

Odoo
on 7/10/14, 3:22 AM

Actually you forgot the postgres password.

Remya
on 7/10/14, 3:43 AM

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

Remya
on 7/10/14, 3:44 AM

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.

Remya
on 7/10/14, 3:46 AM

sudo adduser sudo to add sudo user use this command.

Remya
on 7/10/14, 3:47 AM
1
divya
On 7/10/14, 2:15 AM

Try this command

ALTER USER postgres PASSWORD 'newpassword';

Your Answer

Please try to give a substantial answer. If you wanted to comment on the question or answer, just use the commenting tool. Please remember that you can always revise your answers - no need to answer the same question twice. Also, please don't forget to vote - it really helps to select the best questions and answers!

About This Community

This community is for professionals and enthusiasts of our products and services. Read Guidelines

Question tools

2 follower(s)

Stats

Asked: 7/10/14, 1:27 AM
Seen: 5955 times
Last updated: 3/16/15, 8:10 AM