Re: [cobalt-users] Postgres Databse

[Bruce Timberlake <bruce.timberlake@xxxxxxx>]

Is this what you're looking for?  This is the only script having to do
with PostgreSQL, other than meta-verify, that I'm aware of.

We call this one "RaQ4-SiteList-500Error-Fix.sh (not exactly one word,
but...)

#!/bin/sh
# 8/27/2001 Sun Microsystems, Inc.  
#
# All RaQ 4 systems are subject to a pair of race conditions at
# build.  One may leave /home/tmp with incorrect permissions.  
# The other may misconfigure PostgreSQL.  Both will block
# PostgreSQL from starting properly when the RaQ is powered on.
#
# The first symptom of this condition is an Internal Server
# Error when trying to view the Site List in the Server
# Administration interface.
#
# To correct either error condition, please run this
# script as root on the affected system.
# 
# 
#                  *** WARNING ***
# 
# ONLY RUN THIS SCRIPT ON A NEW OR FRESHLY REBUILT RAQ4
# THAT IS GIVING "INTERNAL SERVER ERROR" WHEN TRYING TO
# VIEW THE VIRTUAL SITE LIST IN THE RAQ ADMIN INTERFACE

echo "Forcing permission 01777 on /home/tmp"
chmod 01777 /home/tmp
echo
echo "Rebuilding PostgreSQL configuration"
mv /var/lib/pgsql /var/lib/headache.pgsql
echo
echo "(Re)Starting PostgreSQL"
/etc/rc.d/init.d/postgresql restart
echo
echo "Reconstructing the home site"
/usr/local/sbin/meta-verify -f -u -s -v -i
echo
echo "Done"


-- 
Bruce Timberlake
Technology Engineer
Sun Cobalt Server Appliances
Sun Microsystems, Inc.

E: bruce.timberlake@xxxxxxx
U: http://www.sun.com/cobalt/