This article shows how to set up a Postgres database system using pgadmin

Note 1 : All screenshots have been done on a computer with the french version of Windows XP. We apologize for the problems encountered because of the identification of the labels.

Note 2 : The following operations are achieved under the account postgres created at the time of the the installation. It is necessary to know the password of this account. If not, you must ask the administrator to do the following operations :

 Starting up of pgadmin Under Windows pgadmin is to find in the menu start -> PostgresQL 8.xx

open pgadmin

The principal window represents the instance of the Postgres server.

pgadmin window

 Configuration of the server : The server has to be configured to over the network without asking any authentication at time of the connexion. Saada supports passwords identification but this feature is only useful for the installation of a departmental SaadaDB.

The configuration file is to find in the menu file->open pg_hba.conf. A file browser appears and shows the file pg_hba.conf. This file is located in the repository of the database system pointed out by the shell variable PG_DATA. This directory is set at the time of the installation. The default value are :
 under Windows : C :\Program Files\PostgreSQL\8.xxx\data
 under Linux : /var/lib/pgsql/data

pg_hba.c onf

Select the file pg_hba.conf. The two first lines correspond to the local connexions and the network IPV4. Those two modes must be configured like it is the case on the following figure (mode trust). By clicking twice you can print it.

network setup

 Creation of a connexion role. This role must have the same name as the Unix or Windows user who is in charge of the installation of Saada. In the figures below the name is michel. To reach the role creation you must open the tree resources of the postgres system : click twice on Server -> starting up of PostgresQL Database Server -> right click on Connection roles -> click on add a connection role.

add user

A role set up window appears (have a look below). The new role must have the same name as the person who installed Saada, that’s to say michel in our example. He must have the right to connect, inherits the rights of his parents and he’s got the permission to create databases.

user setup

The new role appears in the right corner of the window pgadmin.

 Check shell variables (Windows) Open the shell variable editor, menu Start>Configuration>System>Advand ced>Environment variables

Shell Variable Window

Check that the variables PGDATA, PGHOME and PGHOST are correclty set. Ckas aslo that the PATH variable include a pointer on PGHOME\bin (see figure above)

 Check that you can run posgtres from the shell. The Postgres shell displays the version number at starting time. Check that this number matches the installed version but not a previous one (frequent issue with Linux).

 Relaunch the server  : click on the root PostgresQL Database server which appears at the left of the window and then launch the application from the menu tools