Upgrading the External EUQ Database

Procedure

1. Dump the EUQ database from the original PostgreSQL server.
   For details, see Step 1 in Upgrading the External Admin Database.
2. Upgrade the PostgreSQL server to version 9.6, or prepare a new PostgreSQL 9.6 server.
   For details, see Step 2 in Upgrading the External Admin Database.
3. Restore the EUQ database to the PostgreSQL 9.6 server.
   For details, see Step 3 in Upgrading the External Admin Database.
4. Update the EUQ database schema.

    CREATE TABLE
           tb_dl_entry_keys(  id serial NOT
           NULL , 
           distribution_list varchar(256),  submitter
           varchar(256), 
           authentication_code varchar(8),  created_time
           timestamptz,  expired_time
           timestamptz,  heartbeat_time
           timestamptz,  is_logined int4
           DEFAULT 0
   );

5. Detach the original EUQ database.
   1. Log on to the IMSS management console.
   2. Go to Administration → IMSS Configuration → Connections.
   3. Click the Database tab.
   4. Disable the database, select the check box next to the database, and then click Detach.
6. Attach the new EUQ database.
   To attach an EUQ database, click Attach. Type the new EUQ database server IP address, port number, administrator user name, password and database name.