How to Connect to OpenERP 7 Database from pgAdmin: Step-by-Step Guide
How to Connect to OpenERP 7 Database from pgAdmin: Step-by-Step Guide
Connecting a #PostgreSQL #database used by #OpenERP 7 through pgAdmin can be a straightforward process if you follow the right steps. Here is a step-by-step guide on how to connect to a database used by OpenERP 7 from pgAdmin.
Ensure that you have pgAdmin installed and running on your machine. You can download the latest version of pgAdmin from the official website.
Launch pgAdmin and navigate to the Servers section.
Click on the "Add New Server" button to open the "Create - Server" dialog box.
In the "General" tab of the "Create - Server" dialog box, enter a name for the server in the "Name" field.
In the "Connection" tab of the "Create - Server" dialog box, enter the following details:
Host: This is the hostname or IP address of the server where your OpenERP 7 database is hosted. For example, localhost if the database is running on the same machine as pgAdmin.
Port: This is the port number where the database is listening. The default port for PostgreSQL is 5432.
Maintenance database: This is the name of the database where the OpenERP 7 tables are stored. This should be the same as the "dbname" parameter in your OpenERP 7 configuration file.
Username: This is the username used to access the OpenERP 7 database.
Password: This is the password used to access the OpenERP 7 database.
Once you have entered the required details, click the "Save" button to save the server configuration.
You can now expand the server node in the left-hand pane of pgAdmin to view the databases associated with the server.
Expand the database containing the OpenERP 7 tables to view the tables.
You can now view and edit the OpenERP 7 tables using pgAdmin.
In summary, connecting to a database used by OpenERP 7 from pgAdmin requires you to enter the correct server details and credentials. With the right configuration, you can easily view and edit the OpenERP 7 tables using pgAdmin.
By: http://www.mindphp.com