• Article for your preferred language does not exist. Below is international version of the article.

Article ID: 113830, created on May 5, 2012, last review on Dec 23, 2015

  • Applies to:
  • Operations Automation

Overview

This article contains instructions on how to move OA system PostgreSQL database from the Management Node to a separate server. Please note that during the operation, the provisioning engine and control panel will not be available. The new database server should have at least as much memory as the Management Node has.

The migration process consists of two parts: migration of the system database itself (which can be performed in different ways, two of them are described in this article), and configuring Operations Automation (OA) to use the new database server.

Database migration (physical copy)

This method of migration is simpler than the second method described, and it is usually faster. However, you need to use a new database server with the same architecture/OS.

  1. Shut down Operations Automation on the Management Node:

    • before OA 6.0: # /etc/init.d/pem stop

    • OA 6.0: # service pau stop # service pem stop
  2. Shut down PostgreSQL on the Management Node (depending on the OA version):

    • before OA 5.5: # /etc/init.d/postgresql-9.0 stop
    • OA 5.5: # /etc/init.d/postgresql-9.1 stop
  3. Install the PostgreSQL server on the new database server. You need to install the following RPMs from the OA distribution with dependencies(depending on the OA version):

    • before OA 5.5:

      • postgresql90-9.0.4-2.parallels
      • postgresql90-libs-9.0.4-2.parallels
      • postgresql90-server-9.0.4-2.parallels
      • postgresql90-odbc-09.00.0300-1.parallels
      • pgtune-0.9.3-2.parallels.
    • OA 5.5:

      • postgresql90-libs-9.0.10-1PGDG
      • postgresql90-odbc-09.00.0310-3.parallels
      • postgresql91-9.1.6-1PGDG
      • postgresql91-server-9.1.6-1PGDG
      • postgresql91-libs-9.1.6-1PGDG
      • postgresql-libs-8.1.23-1.el5_7.3
      • pgtune-0.9.3-3 (for CentOS6/RHEL6)
      • pgtune-0.9.3-4 (for CentOS5/RHEL5)

    Install all listed RPMs if the database server is x86_64, and install only the i386 RPMs if it is not. Do NOT start the PostgreSQL server yet.

  4. Configure the kernel parameters kernel.shmall and kernel.shmmax on the new database server in the same way they are configured on the OA Management Node:

    1. Copy the lines kernel.shmmax = ... and kernel.shmall = ... from the /etc/sysctl.conf on the Management Node, paste them to the /etc/sysctl.conf on the new database server
    2. Execute the command sysctl -p on the new database server.
  5. Copy the content of the database folder from the OA Management Node to the new database server:

    • before OA 5.5: var/lib/pgsql/9.0/data/
    • OA 5.5: var/lib/pgsql/9.1/data/

    Remember to preserve ownership and permissions of the files. For example, you may do it in the following way:

    • Create archive on the OA Management Node:

      • before OA 5.5: # tar cvf db.tar -C /var/lib/pgsql/9.0/data
      • OA 5.5: # tar cvf db.tar -C /var/lib/pgsql/9.1/data
    • Copy archive to the new database server:

      # scp db.tar $db_server_name:
      
    • Unpack the archive on the database server:

      • before OA 5.5: tar xvf db.tar -C /var/lib/pgsql/9.0
      • OA 5.5: tar xvf db.tar -C /var/lib/pgsql/9.1
  6. Add to chkconfig and start PostreSQL server on the new database server:

    • before OA 5.5: # chkconfig postgresql-9.0 on # /sbin/service postgresql-9.0 start

    • OA 5.5: # chkconfig postgresql-9.1 on # /sbin/service postgresql-9.1 start

If you experience problems with the database start, look at the file /var/lib/pgsql/9.0/pgstartup.log (/var/lib/pgsql/9.1/pgstartup.log for OA 5.5) to identify the reason.

DB migration (export/import)

This way of migration is more complicated than the previous one, but it allows you to migrate the database to a different platform, for example. Also, after this kind of migration, data is organized on the disk in a more optimal way.

  1. Shut down PostgreSQL on the OA Management Node:

    • before OA 5.5: # /etc/init.d/postgresql-9.0 stop
    • OA 5.5: # /etc/init.d/postgresql-9.1 stop
  2. Install the PostgreSQL server on the new database server. You need to install the following RPMs from the OA distribution with dependencies(depending on the OA version):

    • before OA 5.5:

      • postgresql90-9.0.4-2.parallels
      • postgresql90-libs-9.0.4-2.parallels
      • postgresql90-server-9.0.4-2.parallels
      • postgresql90-odbc-09.00.0300-1.parallels
      • pgtune-0.9.3-2.parallels.
    • OA 5.5:

      • postgresql90-libs-9.0.10-1PGDG
      • postgresql90-odbc-09.00.0310-3.parallels
      • postgresql91-9.1.6-1PGDG
      • postgresql91-server-9.1.6-1PGDG
      • postgresql91-libs-9.1.6-1PGDG
      • postgresql-libs-8.1.23-1.el5_7.3
      • pgtune-0.9.3-3 (for CentOS6/RHEL6)
      • pgtune-0.9.3-4 (for CentOS5/RHEL5)

    Install all listed RPMs if the database server is x86_64, and install only the i386 RPMs if it is not. Do NOT start the PostgreSQL server yet.

  3. Configure the kernel parameters kernel.shmall and kernel.shmmax on the new database server in the same way they are configured on the OA Management Node:

    1. Copy the lines kernel.shmmax = ... and kernel.shmall = ... from the /etc/sysctl.conf on the Management Node, paste them to the /etc/sysctl.conf on the new database server
    2. Execute the command sysctl -p on the new database server.
  4. Init the new PostgreSQL database on the new database server:

    • before OA 5.5: /etc/init.d/postgresql-9.0 initdb
    • OA 5.5: /etc/init.d/postgresql-9.1 initdb
  5. Add to chkconfig and start the PostgreSQL server on the new database server:

    • before OA 5.5: # chkconfig postgresql-9.0 on # /etc/init.d/postgresql-9.0 start

    • OA 5.5: # chkconfig postgresql-9.1 on # /etc/init.d/postgresql-9.1 start
  6. Copy the files /var/lib/pgsql/9.0/data/postgresql.conf and /var/lib/pgsql/9.0/data/pg_hba.conf from the OA Management Node to the new database server.

  7. Restart PostgreSQL on the new database server:

    • before OA 5.5: /etc/init.d/postgresql-9.0 restart
    • OA 5.5: /etc/init.d/postgresql-9.1 restart
  8. Shut down Operations Automation services on the Management Node:

    # service pem stop
    
  9. Create dump of the system database on the OA Management Node:

    # pg_dump -Upostgres -h `hostname` -C plesk > plesk.dump
    
  10. Create new database user on the new database server. Execute the command below on the OA Management Node:

    # createuser -Upostgres -h $new_db_server_hostname -SDR plesk
    
  11. Restore the database dump you just created on the new database server. Execute the command below on the OA Management Node:

    # psql -Upostgres -h $new_db_server_hostname -f plesk.dump
    
  12. Stop the PostgreSQL server on the OA Management Node; it is no longer needed there.

Configuring Operations Automation

  • Before OA 6.0

Edit the file /usr/local/pem/etc/odbc.ini on the OA Management Node - change the value of the "Servername" property to the name of the new database server.

Start OA services:

    # service pem start
  • After OA 6.0

    1. Edit the file /usr/local/pem/etc/odbc.ini on the OA Management Node - change the value of the "Servername" property to the name of the new database server.

    2. Edit the file /usr/local/pem/jboss-eap-6.2/standalone/configuration/standalone-full.xml - on the OA Management Node - change the value of the "jdbc:postgresql" property to the name of the new database server.

    3. Start OA services:

.

# service pau start
# service pem start

Search Words

migrate

system database

separate server

take out PostgreSQL DB from the osscore machine

caea8340e2d186a540518d08602aa065 5356b422f65bdad1c3e9edca5d74a1ae e12cea1d47a3125d335d68e6d4e15e07

Email subscription for changes to this article
Save as PDF