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

Novell Cool Solutions: AppNote
By Anilkumar Bolleni

Reader Rating

Digg This - Slashdot This

Posted: 19 Oct 2007

Contents:

Introduction
Prerequisties
Configuring the PostgreSQL Server
Configuring Novell Archive and Version Services
Conclusion

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.

Create group and user which will be used to start postmaster daemon. Run the following commands as root user.

groupadd -r  pguser_pggrp
useradd -r -g  pguser_pggrp -c "PGSQl user" -s /bin/bash pguser

Set the password for Postgre user using passwd command:

passwd pguser
Changing password for pguser.
New Password:
Reenter New Password:
Password changed.

Create the data directory using the following command:

install -d -o pguser -m 700 /opt/pgsql/data

Switch user to pguser and build your initial system databases.

initdb -D /opt/pgsql/data -A password -W

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

Create archive_database