TSCO deployment in a PostgreSQL environment - FAQ

Version 1
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    PRODUCT:

    TrueSight Capacity Optimization


    COMPONENT:

    Capacity Optimization


    APPLIES TO:

    TrueSight Capacity Optimization 11.x



    QUESTION:

    We are looking to deploy TrueSight Capacity Optimization using a PostgreSQL database.   
        
    • Question 1: Is there a package available for download from the BMC Electronic Product Distribution (EPD) site that will deploy and configure a PostgreSQL database for TSCO ?
    •   
    • Question 2: When using a PostgreSQL database is it a supported configuration for the TSCO Administrator to own and maintain the database rather than having a formal DBA involved?
    •   
    • Question 3: Can the PostgreSQL database server be installed on the same machine as the TSCO Application Server?
    •   
    • Question 4: Is there any default configuration suggested?
    •   
    • Question 5: How I can tune my PostgreSQL Database?
    •   
    • Question 6: How I can investigate on performance of my PostgreSQL database?
    •   
    • Question 7: On the TSCO Application and ETL servers, is there any equivalent to oracle client that needs to be installed to connect to the PostgreSQL server?
    •   
    • Question 8 : What is the scalability of Postgres for a day?
    •  


    ANSWER:

     

    Q: Is there a package available for download from the BMC Electronic Product Distribution (EPD) site that will deploy and configure a PostgreSQL database for TSCO?

    he DB server is an external requirement. BMC does not distribute or install the PostgreSQL Server   and we not provide the packages in our download site (EPD). For Hardware and Software requirements see TrueSight Capacity Optimization documentation of the version you are going to install for the details about hardware and software requirement for the database server.  

    Q: When using a PostgreSQL database is it a supported configuration for the TSCO Administrator to own and maintain the database rather than having a formal DBA?  
       
    1. The PostgreSQL database must be managed by an official PostgreSQL database administrators. So, the process would be:
    2.  
    3. The company in-house IT departments are supposed to install  a PostgreSQL instance according the requirements in the TrueSight Capacity Optimization documentation.
    4.  
    5. Your DBAs provide you the PostgreSQL database administrator username and password which you specify as part of the TSCO installation. TSCO installer will then create the users, roles, and tablespaces necessary within the Postgres database.
      


    Make sure the Postgres database version is supported with TSCO integration, the official Product documentation (Database Server requirements section) contains more specific information about which Postgres versions are supported in regards to TSCO version, in case of any doubt contact Technical Support.

    Q: 
    Can the PostgreSQL database server be installed on the same machine as the TSCO Application Server?

    As per official TSCO documentation, the DB server must be installed on a separate server. Installing the database on the same server as any TSCO component is not a supported configuration. The supported configuration that Technical Support recommends is to allocate the Database Schema on a dedicated server regardless whether it is a PROD or TEST environment.

      

    Q: Is there any default configuration suggested?

    Refer to official TSCO documentation: there is a basic configuration for the PostgreSQL database: in detail which parameters set in postgresql.conf file

    Q: How I can tune my PostgreSQL Database?

    You can use pgtune command (see next point)

    Q: How I can investigate on performance of my PostgreSQL database?

    There is a way to generate performance report (similar to Oracle AWR). You can refer to PosgreSQL official site (https://www.postgresql.org/about/news/1537/). Also you can refer to this article: this will provide more details about the configuration tuning and how investigate in case of I/O performance issue on your PostgreSQL DB server https://bmcsites.force.com/casemgmt/sc_KnowledgeArticle?sfdcid=000129150

    Q: On the TSCO Application and ETL servers, is there any equivalent to oracle client that needs to be installed to connect to the PostgreSQL server?

    The pg_hba.conf file enables client authentication between the PostgreSQL server and the client application. This file consists of a series of entries , which define a host and its associated permissions (e.g., the database it is allowed to connect to, the authentication method to use, and so on). When an application requests a connection, the request will specify a PostgreSQL username and database with which it intends to connect to PostgreSQL. Optionally, a password may be provided, depending on the expected configuration for the connecting host (PostgreSQL has its own user and password tables, which are separate from system accounts. It is not required that your PostgreSQL users match users available to the operating system).

    Q. What is the scalability of Postgres for a day?

    The scalability of Postgres is 80M rows a day

     


    Article Number:

    000272341


    Article Type:

    FAQ/Procedural



      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles