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.
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.