Forum OpenACS Q&A: Response to PostgreSQL from scratch

Collapse
Posted by Vinod Kurup on
Hi Torben,

what does echo $LD_LIBRARY_PATH return? It should have /usr/local/pgsql/lib in it. This is usually set in the .bash_profile file in postgres's home directory.

Since, I've been installing and reinstalling frequently while working on the install guide, i've made some sparse notes on how to wipe an openacs4 pg installation. These are rough and very debian-specific, but if people think this is valuable, i'll put it together into a more formal document:

Stop any aolserver instances:
inittab:
  1. clearing out entries from /etc/inittab
  2. run /sbin/init q to re-read /etc/inittab
  3. killall -9 nsd to kill any running servers
daemontools
  1. stop daemontools - /etc/init.d/daemontools stop
  2. killall -9 nsd to kill any running servers
Stop postgresql
  1. /etc/init.d/postgresql stop
  2. update-rc.d -f postgresql remove (chkconfig for RH)
Remove vacuumdb from crontab (crontab -e)

Get rid of nsadmin and postgres users and files

  1. deluser --remove-all-files nsadmin
  2. deluser --remove-all-files postgres
Get rid of web group
  1. groupdel web
Get rid of extra files:
  1. rm -r /usr/local/pgsql (relkov.so from OpenFTS still in there)
  2. rm /etc/init.d/postgresql
  3. rm -r /usr/local/aolserver /web /usr/lib/tcl8.3/nsfts-0.1
  4. rm -r /usr/local/bin/restart-aolserver /usr/local/bin/svgroup /usr/local/src/root /usr/local/src/postgresql
  5. rm -r /service/
get rid of daemontools:
  1. apt-get --purge remove daemontools