Installation Prerequisites

Before you install IBM® Connect:Direct® Web Service on AIX complete the following procedure to initialize and configure PostgreSQL database.
Note: This procedure only applies for IBM Connect:Direct Web Service v6.0.0.5 and above users.
  1. Invoke the following command to list all PostgreSQL database packages: 
    yum list postgresql*
  2. Invoke the following command to install PostgreSQL v9.2 database. 
    yum install postgresql-server
  3. Invoke the following command to initialize and configure a PostgreSQL database.
    1. The PostgreSQL data directory contains all data files required to configure and initialize the database. Variable PGDATA is used to reference this directory. The default data directory is /var/lib/pgsql/data.
    2. To initialize the database create a directory and use chown command to assign all privileges to that directory.

      Add a PostgreSQL database user to the PostgreSQL group using the chown -R command, with data directory, logged in as a PostgreSQL user.

      root@zrh07xxd var]# mkdir AIXPostgres
[root@zrh07xxd var]# chown -R 777/var/AIXPostgres/
[root@zrh07xxd var]# chown -R postgres:postgres/var/AIXPostgres/
[root@zrh07xxd var]# cd AIXPostgres/
[root@zrh07xxd testpg]# su - postgres
Last login: Tue Dec 17 12:59:14 CST 2019 on pts/2
    3. Invoke the initdb command from the bin folder and define the directory created in the steps above followed by argument -D.
    4. Use -W -A arguments to prompt user for password-based authentication. 
      bash-5.0$ ./initdb -U postgres -D "/var/AIXPostgres" -W -A md5
The files belonging to this database system will be owned by user "postgres".
This user must also own the server process.

The database cluster will be initialized with locale "en_US".
The default database encoding has accordingly been set to "LATIN1".
The default text search configuration will be set to "english".
Data page checksums are disabled.
Enter new superuser password:
Enter it again:

fixing permissions on existing directory /var/AIXPostgres... ok
creating subdirectories ... ok
selecting default max_connections ... 100
selecting default shared_buffers ... 128MB
selecting default timezone ... CST6CDT
selecting dynamic shared memory implementation ... posix
creating configuration files ... ok
running bootstrap script ... ok
performing post-bootstrap initialization ... ok
syncing data to disk ... ok

Success. You can now start the database server using:

    ./pg_ctl -D /var/AIXPostgres -l logfile start