Novell Home

Configuring Novell Archive and Version Services using Pre-Configured PostgreSQL Server

Novell Cool Solutions: AppNote
By Anilkumar Bolleni

Digg This - Slashdot This

Posted: 19 Oct 2007
 

Contents:

Introduction

Novell Archive and Version Services helps a user to recover previous versions of modified, renamed or deleted files quickly and relatively painlessly. The user simply views a list of previous interval-based versions of the files, selects the required file and recovers it. The user is no longer requireed to wait for the administrator to recover a changed or accidentally deleted file.

The user can recover a single version or multiple versions of current files or deleted files. If the user works in a collaborative environment, the user can determine which version to choose based on the modified time or the user who modified it.

This appnote explains a way to configure Novell Archive and Version server on an already configured PostgreSQL server. This is useful if a user has configured the PostgreSQL database earlier and wants the Novell Archive and Version Service to use the same database server.

Prerequisties

Install the PostgreSQL packages selected below on the OES2 server.

  • postfix
  • postgresql
  • postgresql-devel
  • postgresql-jdbc
  • postgresql-libs
  • postgresql-server
  • psqlODBC
  • PyGreSQL


Configuring the PostgreSQL Server

Configure PostgreSQL server using the following steps:

Note: Use these steps if you have not configured postgresql server.

  1. Create group and user which will be used to start postmaster daemon. Run the following commands as root user.
  2. groupadd -r  pguser_pggrp
    useradd -r -g  pguser_pggrp -c "PGSQl user" -s /bin/bash pguser 
  3. Set the password for Postgre user using passwd command:
  4. passwd pguser
    Changing password for pguser.
    New Password:
    Reenter New Password:
    Password changed.
  5. Create the data directory using the following command:
  6. install -d -o pguser -m 700 /opt/pgsql/data
  7. Switch user to pguser and build your initial system databases.
  8. initdb -D /opt/pgsql/data -A password -W


  9. Now you will be ready to start the postmaster, which keeps track of all the postgres processes. You will need to specify the '-D' option. This option specifies the location of the the data directory and it is recommended to use the '-i' flag, which tells it to listen on TCP/IP ports as well as Unix Sockets.

    - To start the postmaster:
    postmaster -D /opt/pgsql/data -h 127.0.0.1 -p 5555 -i
    - To verify the postmaster:
    ps -ef | grep post
    root     12302     1  0 11:14 ?        00:00:00 /usr/lib/postfix/master
    postfix  11221 12302  0 12:19 ?        00:00:00 pickup -l -t fifo -u
    postfix  11222 12302  0 12:19 ?        00:00:00 qmgr -l -t fifo -u
    pguser     945     1  0 13:06 ?        00:00:00 postmaster -D /opt/pgsql/data -h  127.0.0.1 -p 5555 -i
    pguser     951   945  0 13:06 ?        00:00:00 postgres: logger process 
    pguser     955   945  0 13:06 ?        00:00:00 postgres: writer process 
    pguser     956   945  0 13:06 ?        00:00:00 postgres: stats buffer process 
    pguser     957   956  0 13:06 ?        00:00:00 postgres: stats collector proces s
    pguser    2474 11798  0 13:06 pts/2    00:00:00 grep post

  10. Create archive_database


Configuring Novell Archive and Version Services

  1. Open the Yast and select the OES install and configuration icon under OES section.. Select Novell Archive and Version Services under OES services.


  2. Select the Arkmanager.


  3. Enter database parameters port number, username and password of the postgreSQL server which was configured earlier.


  4. Start the Archive server using /etc/init.d/novell-ark script.

  5. Now configure the archive volume and archive jobs as specified in Novell Archive and Version Services admin guide.

Conclusion

The steps given above will configure the Novell Archive and Version Services on an already configured and running PostgreSQL server. This will be useful for the users who want to use the Novell Archive and Version Services with their Configured postgreSQL server.


Novell Cool Solutions (corporate web communities) are produced by WebWise Solutions. www.webwiseone.com

© 2014 Novell