Migrating from embedded PostgreSQL to external PostgreSQL database

  1. Back up the embedded PostgreSQL database on the BMC Server Automation application server. 
  2. Install the PostgreSQL database server on a new computer.
  3. Create a superuser role named bcan having login privileges with password as bcan2226.
    The following figure shows a sample user: 
    LoginUser.png 
  4. Copy the database dump from the application server to the PostgreSQL database server.
  5. Log in to the database server as the bcan user.
  6. Create a database named bcan.
  7. Restore the database dump to the bcan database either using the pgAdmin III tool or follow these instructions:
    1. Navigate to the C:\Program Files (x86)\PostgreSQL\<version>\bin directory.

    2. Run the following command:

      pg_restore.exe --host localhost --port 5432 --username "bcan"  --dbname "bcan"  --section pre-data --section data --section post-data --schema public --verbose "C:\bcan.dump"
    3. When prompted for password, enter bcan2226. 
  8. Stop the BCA-Networks Web Server service and the embedded database service.
  9. On the application server, modify the database.properties file, as follows:
    1. Navigate to the BCAN_DATA directory and open the database.properties file with a text editor.

    2. Change the database server host name and port number, as follows:
      From:

      bna.jdbcRealm.connectionURL=jdbc:postgresql://localhost:15432/bcan

      To:

      bna.jdbcRealm.connectionURL=jdbc:postgresql://databaseServerHostName:databaseServerPortNum/bcan

      Replace databaseServerHostName and databaseServerPortNum with actual values.

  10. Modify the catalina.properties file, as follows:
    1. Navigate to the BCAN_HOME\tomcat\conf directory and open the catalina.properties file with a text editor.

    2. Change the database server host name and port number, as follows:
      From:

      bna.jdbcRealm.connectionURL=jdbc:postgresql://localhost:15432/bcan

      To:

      bna.jdbcRealm.connectionURL=jdbc:postgresql://databaseServerHostName:databaseServerPortNum/bcan

      Replace databaseServerHostName and databaseServerPortNum with actual values.

  11. Modify the BcanInstalledConfiguration.xml file, as follows:
    1. Navigate to the BCAN_HOME directory and open the BcanInstalledConfiguration.xml file with a text editor.

    2. Change the database type, database server host name, port number, installation type, and database URL as follows.
      The contents of the existing file are:

      <property>   
      <name>DATABASE_TYPE</name>    
      <value>Postgresql (Embedded)</value>
      </property>
      <property>
      <name>DATABASE_HOSTNAME</name>    
      <value>localhost</value>
      </property>
      <property>     
      <name>DATABASE_PORT_NUMBER</name>     
      <value>15432</value>
      </property>
      <property>     
      <name>BCAN_SERVER_INSTALL_SET_SELECTION</name>     
      <value>TYPICAL</value>
      </property>
      <property>
      <name>DATABASE_URL</name>    
      <value>jdbc:postgresql://localhost:15432/bcan</value>
      </property> 

      Change the attributes as follows. 

      <property>   
      <name>DATABASE_TYPE</name>    
      <value>Postgresql</value>
      </property>
      <property>
          <name>DATABASE_HOSTNAME</name>     
      <value>databaseServerHostName</value>
      </property>
      <property>  
      <name>DATABASE_PORT_NUMBER</name>   
      <value>databaseServerPortNum</value>
      </property>
      <property>   
      <name>BCAN_SERVER_INSTALL_SET_SELECTION</name>
          <value>CUSTOM</value>
      </property>
      <property>
      <name>DATABASE_URL</name>
      <value>jdbc:postgresql://databaseServerHostName:databaseServerPortNum/bcan</value>
      </property> 

      Replace databaseServerHostName and databaseServerPortNum with actual values.

  12. Start the BCA-Networks Web Server service.


 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*