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.
New to ADSelfService Plus?
Related Articles
Moving OpManager from one server to another server without reinstalling OpManager
Question : How do I move OpManager from one server to another without reinstalling OpManager. Solution: It is easy to move OpManager from one Server to another just by copying the complete OpManager folder and installing the service. Steps: 1)Stop ...How to install OpManager Central and Probe on a Windows server (PGSQL)
Unable to start OpManager - PGSQL
Sometimes OpManager will not start when the server ran out of disk space in the pg_xlog directory. It will not be possible to retrieve the connection to OpManager database. The files present under OpManager\pgsql\data\pg_xlog get disappeared in such ...OpManager DB migration from PGSQL to MSSQL on the same server in Version 12.3
Please follow the below mentioned steps to migrate DB from PGSQL to MSSQL on the same server. These steps are applicable only on builds 12.3.045 and above. If you are in older versions below 12.3.045, please upgrade to 12.3.045 and follow these ...OpManager DB migration from PGSQL to MSSQL in Version 125230
For OpManager version 125230: PGSQL to MSSQL Migration Steps : In the PGSQL setup, go to OpManager home → bin, start Command Prompt with administrator privilege from this path and run DBConfiguration.bat. In the popup shown, please chose MSSQL, check ...