Setting Up Postgres 12 Database

The Call History Postgres Database stores all the Call History records for MiVoice Business Console operators.

1. Download the Postgres Server Installation package from the website:

   https://www.postgresql.org/download/windows/

   

   

2. Execute the downloaded installation package.

   The Setup wizard appears.

3. In Setup wizard, under Select Components, clear the Stack Builder check box, and click Next.

   Note: By default, all the check boxes are selected.
   

4. Specify the database location and click Next.

   Note: It is recommended to create a sub-folder 12.1 to differentiate between future Postgres Server versions.

5. Enter a password for the Postgres user and click Next.

   Note: This password is used by Postgres SQL server database administrator when migrating to a newer version of Postgres.

6. Do not modify the default Port number (5432) and click Next.

7. Do not modify the default Locale ([Default locale]) and click Next.

   The Summary window is displayed.

8. Click Next.

   The Ready to Install window is displayed.

9. Click Next.

10. After the installation is complete, click Finish.

11. Open the pgAdmin 4 application to connect to the database server.

    The application displays the current server.

12. Enter a master password and click OK.

    

13. Expand Servers to view currently installed Postgres 12.1 server.

    

14. Enter a password and click OK.

    

15. Right-click Servers, point to Create, and click Server.

    The Create -Server dialog is displayed.

    

16. In the Name field, enter the name of the server. For example, Local Host.

17. Click the Connections tab, and enter the following details:

    

    • Host name/address- enter localhost or the DNS name of your remote computer.

    • Port- enter 5432 as the port number.

    • Maintenance database- enter a name for the maintenance database.

    • Username- enter a user name for the server.

    • Password- enter a password for the Postgres user.

18. Click Save.

19. Create a role with the name:

    1. Expand Local Host, right-click Login/Group Roles, point to Create, and click Login/Group Role.

       The Create - Login/Group Role dialog is displayed.

       
    2. In the Name field, enter ipconsoleattendant.
       Note: A new login role must be added before creating the database. The ipconsoleattendant account is used by all consoles for logging in. The same login role can be simultaneously used by all MiVoice Business consoles.
    3. In the Comments field, enter comments for the role.

    4. Click the Definition tab.

       

    5. Enter password for the role.

       Note: This password is configured on each MiVoice Business Console on Call History option form. If it is an upgrade to a newer Postgres Server, it is recommended to reuse the existing ipconsoleattendant password.

    6. Click Privileges tab and set Yes for all the privileges except Can initiate streaming replication and backups?

       

    7. Click Save.

20. Create a database with the name IP_CONSOLE_5550:

    1. Expand Local Host, right-click Databases, point to Create, and click Database.

       The Create - Database dialog is displayed.

       

    2. In the Name field, enter IP_CONSOLE_5550.

    3. In the Comments field, enter comments for new database.

       Note: Although 5550 IP Consoles are no longer supported, the name IP_CONSOLE_5550 is chosen so that the customers migrating from 5550 IP consoles to MiVoice Business consoles can retain their previous database entries.

    4. Click Save.

       The database IP_CONSOLE_5550 is created.

       Note: The call_history table is created by the first console that connects to the database.

To set Postgres network parameters:

1. Open the pg_hba.conf file in the Notepad application.

   Note: Typically, the file is located in the C:\Program Files\PostgreSQL\12\data directory.

2. Scroll to the bottom of the file and add the network parameters as shown in the following example.

   

3. On the File menu, click Save, and close the file.