PostgreSQL Database

The following is a requirement of the PostgreSQL database. If the file is missing or the settings are incorrect, database startup errors.

Requirements for Solaris 9

The following file and settings need to be present:

• /etc/system

• set semsys:seminfo_semmns=16384

• set semsys:seminfo_semmni=1024

Create OS User and Group

N1 AA packages are dependent on this user and group. The creation of both is only necessary if the user and group are not in LDAP.

1. Create OS group n1aa.

   # /usr/sbin/groupadd n1aa

2. Create OS user n1aa (assigned to group n1aa).

   # /usr/sbin/useradd -d /opt/SUNWn1aa -g n1aa n1aa

3. Assign password to user n1aa

   # passwd n1aa

Install Database Software

1. If the /opt/SUNWn1aa/pgsql directory already exists, move it to a backup location by using the following command:

   # mv /opt/SUNWn1aa/pgsql /opt/SUNWn1aa/pgsql_backup

2. Copy the package SUNWn1aapgsql.pkg from the installation media to a temporary installation directory. Navigate to that directory.

3. Install the package SUNWn1aapgsql.pkg as superuser:

   # pkgadd -d SUNWn1aapgsql.pkg

   This following are installed:

   • PostgresSQL

   • Database n1aa

   • Start and stop scripts on Solaris 9 or system management facility (smf) manifest on Solaris 10

     The pkgadd command prompts for the port of the N1 AA PostgreSQL on which the database listens. The standard port is 5433.

4. Start the database on Solaris 9.

   # /etc/init.d/n1aapgsql start

Test login

1. Login to the database to verify a successful installation. As user n1aa:

   # /opt/SUNWn1aa/pgsql/bin/psql -p 5433 n1aa

   You should now be connected to the PostgreSQL database n1aa.

2. List the table count.

   # n1aa=# \dt

   A list of 32 rows should be displayed.

3. Exit the sql-Editor.

   # n1aa=#\q