Skip to Content
This question has been flagged
Odoo12.0
2 Replies
7323 Views
Avatar
SAMET Mohamed Nidhal

Hi,

i want to access Odoo database using pgAdmin3,

My scenario:

I have my Odoo running on ubuntu server in virtual box

I have installed pgAdmin4 on my localhost machine

when opening pgAdmin4 and selecting New Server Registration

this is my entry:

Name: odoo

Host: 192.168.1.114 (this is the ip if you 'ifconfig' in the virtual box )

Port: 5432 (default didn't change anything)

Username: admin (this is my usernane in odoo , admin account)

Password: admin (my ppassword in odoo)

Group: Servers

There is error after proceeding

An error has occurred:

Error connecting to the server: FATAL: password authentication failed for user "admin"
FATAL: password authentication failed for user "admin"

what (username and password) should i enter there to connect to Odoo, i want to see records of tables there for example res_usersV


please help, Thank you

Avatar
Discard
Avatar
Dario Concilio
Best Answer

Could I have some info on how to install pgadmin4? I have found several tutorials, but I think I have problems with python versions. I use Odoo 12.0-20200222 (Community Edition) on Ubuntu 18.04.4 LTS

Avatar
Discard
Avatar
Avinash Nk
Best Answer

Hello,

In the .conf file of Odoo, you can find the following details.

db_port = 5432
db_user = odoo10
db_password = odoo10
Here db_user, db_password are the User name & Password for the postgres.

Thanks & Regards

Avinash N K

Avatar
Discard
Related Posts Replies Views Activity
How to Limit Pos Category in Odoo 12 Shop?
Odoo12.0
Avatar
0
Mar 24
274
Why is the product_id initiated by default_product_id is NOT available during saving.
Odoo12.0
Avatar
0
Oct 22
1491
compare the lines in one2many fields
Odoo12.0
Avatar
0
Sep 22
660
Tabula python library File not found in odoo 12
Odoo12.0
Avatar
Avatar
1
Jul 22
4084
Odoo 12 chart of account
Odoo12.0
Avatar
0
Jun 22
836