DX Application Performance Management

Expand all | Collapse all

PostGres Installation problem

Jump to Best Answer
  • 1.  PostGres Installation problem

     
    Posted 09-18-2018 05:54 AM
    Hi all,
    during Postgres (APM10.7.0.45) installation we get the following error:
     
    Install Database Failed
    Status: ERROR
    Additional Notes: ERROR - (STDOUT: Found RedHat version 7
    Shared memory size optimal for postgres.
    Problem running post-install step. Installation may not complete correctly
    The database cluster initialisation failed.
    Install Postgres failed with exit code 1
    )
     
    Any suggestion for a possible checklist?
     
    Thank You in advance
     
    Marco


  • 2.  Re: PostGres Installation problem

    Posted 09-18-2018 08:55 AM

    Dear Community:

    Please feel free to respond to Marco. Have you seen this before? What solved the issue for you?

     

    Dear Marco 

    RedHat 7 and Postgres on APM 10.7 is supported

     

    PCM for CA Software - Agile Operations Product Compatibility Search 

     

     

    I would check the postgres install logs especially post-install logs

    Problem running post-install step. Installation may not complete correctly



  • 3.  Re: PostGres Installation problem

    Posted 09-18-2018 01:27 PM

    Marco, would there have been pre-existing Postgres instance installed on this Redhat 7 server?

     

    Francis



  • 4.  Re: PostGres Installation problem

    Posted 09-18-2018 04:17 PM

    Hi Marco,

     

    Please attach the postgres install logs.  Also as Francis said, check if there is another instance of Postgres on there.  Generally some Redhat distributions already have a pre-installed postgres.

     

    Matt



  • 5.  Re: PostGres Installation problem

    Posted 09-18-2018 07:41 PM

    Hi Marco,

    In addition to what Francis & Matt suggested is this a root or non-root install?

    Thanks

    Lynn



  • 6.  Re: PostGres Installation problem

    Posted 09-19-2018 03:27 AM

    Hi Marco,

     

    I have checked a similar issue and I believe Lynn is right. I guess you are using non-root user for the installation and it is trying to overwrite some folders owned by the root.

     

    Cheers

    Jose



  • 7.  Re: PostGres Installation problem
    Best Answer

     
    Posted 09-19-2018 04:14 AM

    Hi all,

    thank for answer.

    This is a new installation, executed under root user.

    Examining postgres-log file we found:

     

    initialising the database cluster (this may take a few minutes)...
    Executing /appl_bin/CA/APM10.7.0/APMDB/installer/server/initcluster.sh "postgres" "postgres" "/appl_bin/CA/APM10.7.0/APMDB" "/appl_bin/CA/APM10.7.0/APMDB/data" 5432 DEFAULT
    Script exit code: 1

    Script output:
    Failed to initialise the database cluster with initdb

    Script stderr:
    su: warning: cannot change directory to /appl_bin/CA/APM10.7.0/APMDB: Permission denied
    -sh: /appl_bin/CA/APM10.7.0/APMDB/.profile: Permission denied
    -sh: /appl_bin/CA/APM10.7.0/APMDB/bin/initdb: Permission denied

     

    So it seems a problem related at the permissions on the folders.

    We solved forcing a chmod 777 on the dbscripts and installation folder.



  • 8.  Re: PostGres Installation problem