Configure PostgreSQL for PgAdmin3

PgAdmin 3 is a database manager for the PostgreSQL, however, it does not install on the some platform along with the installation of PostgreSQL. PgAdmin3 will be installed on Windows and Mac along with the PostgreSQL, to install on Linux you need to install some additional packages and need some configuration.

Untitled11

Install & Configure

Install pgadmin3 on Ubuntu

openerp@openerp-desktop:/$ sudo apt-get install pgadmin3
Or install pgadmin3 on Fedora, CentOS, Redhat

openerp@openerp-desktop:/$ sudo yum install pgadmin3
The Default password for the user postgres is not set, to connect pgadmin3 with PostgreSQL you need to reset the password of postgres user. Use the command below to reset the password.

Check for database template1 and connect to the same

postgres@openerp-desktop:/$ psql -l
postgres@openerp-desktop:/$ psql template1
Reset the password for the postgres or any other user you plan to use to manage your databases, run below command to reset the password.

template1=# alter role postgres with password ‘postgres’;
ALTER ROLE

Test Connection

To access your database using pgAdmin 3, you must configure the database connection as shown in the following figure:

Untitled11

Click on Ok to save server settings and you will be asked for a password each time when you connect to the PostgrSQL server.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s