Community and Support

            Moving PGSQL to a dedicated server


            1. Install PostgreSQL version 9.2.1 on the dedicated server. After successfully installing it

            2. Go to data directory of PostgreSQL installation.

            3. Open pg_hba.conf - PostgreSQL Client Authentication configuration file, and go to the bottom of it.

            4. By default, under IPv4 local connections, we have the following:

            host all all 127.0.0.1/32 md5/trust md5/trust or someother is available as last option

                  1. Change the 127.0.0.1/32 to all

            5. By default, under IPv6 local connections, we have the following:

            host all all ::1/128 md5/trust md5/trust or someother is available as last option

                  1. Change the ::1/128 to all

            6. Save the File.

            7. Open Services window and restart the PostgreSQL server running in the machine to effect the changes.

            8. Edit the file /opmanager/conf/database_params.conf

            9. Configure the host name and the PostgreSQL port number for the url parameter as given below: 

              url jdbc:postgresql:// <name of the server where postgresql is installed> : <postgresql port> /OpManagerDB

              Example: url jdbc:postgresql://database1-server:5432/OpManagerDB

            10. If you wish to enable password, un-comment the password line and set the new password.

            11. Edit customer-config.xml under <opmanager_home>/conf and change StartDBServer to false (as below)

                       <configuration name="StartDBServer" value="false"/>

            12. Then connect the installed Postgresql from command prompt and run this query

            create database "OpManagerDB";    

            13. Stop that Postgres 

            14. Start opmanager service


            Exclude 8, 9, 10 points if you're moving to separate drive on the same server where opmanager is installed.
            Updated: 11 Oct 2017 05:43 AM
            Helpful?  
            Help us to make this article better
            0 0