Moving the ZLM 6.6.2 Postgres Database to a larger volume

  • 3200448
  • 31-Oct-2007
  • 27-Apr-2012

Environment


Novell ZENworks 6.6.2 Linux Management - ZLM6x database

Situation

The database has outgrown the volume.

Resolution

This is what was done to move pgsql from /var/lib (installed volume) to /linuxzlmvol (new volume)

1. Stop rcq-runner, apache, and pgsql (rhdb on red hat):
/etc/init.d/rcq-runner stop
/etc/init.d/httpd stop
/etc/init.d/rhdb stop

2. Copy the database preserving ownership and perms: cp /var/lib/pgsql /linuxzlmvol

Validate the copy then move the database from the /var/lib area to be sure nothing was picked up from /var/lib/pgsql.

3. Edit all instances of PGDATA=/var/lig/pgsql/data to PGDATA=/linuxzlmvol/pgsql/data in /linuxzlmvol/pgsql/.bash_profile and /etc/init.d/rhdb (other distros would edit the appropriate pgsql init file).

4. Change /var/lig/pgsql/data entries in the /linuxzlmvol/pgsql/data
/postmaster.opts and /linuxzlmvol/pgsql/data/postmaster.pid to
/linuxzlmvol/pgsql/data

5. Start it all back up:
/etc/init.d/rhdb start
/etc/init.d/rcq-runner start
/etc/init.d/httpd start

This document is not inclusive for all potential ZLM 6.6.2 installations. The information can be used as a starting point for different environments. Feedback is welcome.

Additional Information

The ZLM 7.2 installation is different than 6.6.2 and is not included in this TID.