PostgreSQL database is manually configured error

  • 7006852
  • 15-Sep-2010
  • 27-Apr-2012

Environment

Novell Open Enterprise Server 2 (OES 2) Linux Support Pack 2
Novell Archive and Version Service

Situation

Novell Archive and Version Service will not start up.  It fails with this error:

PostgreSQL database is manually configured, ensure that the database is started before starting the service
Novell Archive and Version Service failed to start


Resolution

1.  Check the /opt/novell/arkmanager/bin directory for a file named pg_restart.sh.  Check inside the file to make sure it is pointing to the correct directory for your database.  If running with NCS, this will be different than the default /var/opt/novell/arkmanager/data directory.  It should match what you have in /etc/opt/novell/arkmanager/conf/arkdatadir.conf.

2.  If the pg_restart.sh does not exist, you can use the pg_init.sh script in the same directory to create it.
    -  export REINSTALL=1
    -  /opt/novell/arkmanager/bin/pg_init.sh --Ark-user=arkuser --Ark-passwd=novell --db-port=5432 (substitute your own values for the variables if different)

Running the pg_init.sh should recreate the pg_restart.sh script.  Verify the contents point to the correct database location as mentioned in step 1.

3.  Start up the Archive and Version Service to verify it is now working (rcnovell-ark start)

4.  Type this in to verify that it is using the correct database location path:
  # ps -ef |grep postmaster

You should have output similar to this:
  postmaster -D /var/opt/novell/arkmanager/data -h 127.0.0.1 -p 5432 -i

Note:  Your database location should match what you have set already in pg_restart.sh and arkdatadir.conf files (step 1).