Hi Rajeev,
this is my startup script. You add -d {number} depending on the debug level you
want.
hope this helps.
anil
Rajeev Bacchu wrote:
> Hi anil,
>
> Thank u ver much, let me sit down right now & follow what u have said, &
> just one more thing, can u tell me how to start postgresql with -i option? U
> r way ahead of me with these things so I am sure u'd know. I just want to
> avoide the time running through the docs for this.
>
> thank u,
>
> -Rajeev B.
>
> -----Original Message-----
> From: [EMAIL PROTECTED]
> [mailto:[EMAIL PROTECTED]]On Behalf Of
> [EMAIL PROTECTED]
> Sent: Wednesday, April 11, 2001 1:08 AM
> To: [EMAIL PROTECTED]
> Subject: Re: [JBoss-user] CMP Postgres and Booleans
>
> Hi,
>
> Here we go Rajeev, with top half of the jboss.jcml.
> Make sure you started postgres with -i option on.
> Check your pg_hba.conf is right.
> and postgresql.jar in $JBOSS_HOME/lib/ext .
> jboss will hang if it cannot find postgresql.jar.
>
> anil
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
#!/bin/sh
#
# postgres.init.sh - This script is used to start/stop
# the postgreSQL listener process.
#
# Usage
#
# You can use this script manually, and/or you
# can install this script into the runlevel system
# by running "sh postgres.init.sh install"
#
# Credits
#
# Thomas Lockhart <[EMAIL PROTECTED]>
# modified from other startup files in the
# RedHat Linux distribution
#
# Clark Evans <[EMAIL PROTECTED]>
# cleaned up, added comments, etc.
#
# RedHat Stuff
#
# chkconfig: 345 85 15
# description: Starts and stops the PostgreSQL backend daemon\
# that handles all database requests.
# processname: postmaster
# pidfile: /var/run/postmaster.pid
#
#
# Note
#
# This version can log backend output through syslog using
# the local5 facility. To enable this, set USE_SYSLOG to "yes"
# below and then edit /etc/syslog.conf to include a line
# similar to:
#
# local5.* /var/log/postgres
#
# Config Variables
#
PGACCOUNT="postgres"
#
# The non-root user account which will be used to run the
# PostgreSQL executeable. For this script to work, the
# shell for this account must be SH/BASH.
#
# The following lines should be in this account's .bash_profile
#
# PATH=$PATH:$HOME/bin
# MANPATH=$MANPATH:/opt/pgsql/man
# PGLIB=/opt/pgsql/lib
# PGDATA=/opt/pgsql/data
#
POSTMASTER="postmaster"
#
# The executable program which is to be run, in this case
# it is the listener, which waits for requests on the port
# specified during configuration.
#
USE_SYSLOG="yes"
#
# "yes" to enable syslog, "no" to go to /tmp/postgres.log
#
FACILITY="local5"
#
# can assign local0-local7 as the facility for logging
#
PGLOGFILE="/var/log/postgres"
#
# only used if syslog is disabled
#
#PGOPTS="-B 256"
#
# The B option sets the number of shared buffers
#
# Add the "-i" option to enable TCP/IP sockets in addition
# to unix domain sockets. This is needed for Java's JDBC
#
#PGOPTS="-d 1 -i -B 256"
PGOPTS="-i -B 256"
#
# Add the -D option if you want to ovverride the PGDATA
# environment variable defined in
#
# PGOPTS="-D/opt/pgsql/data
#
# Add the -p option if you would like the listener to
# attach to a port other than the one configured (5432?)
#
# PGOPTS="-D/opt/pgsql_beta/data -p 5433"
#
# Source function library.
. /etc/rc.d/init.d/functions
# Get config.
. /etc/sysconfig/network
echo -n "Checking postgres: "
#
# Check that networking is up.
# Pretty much need it for postmaster.
#
if [ ${NETWORKING} = "no" ]
then
exit 0
fi
#[ -f /usr/local/pgsq//bin/postmaster ] || exit 0
#
# See how we were called.
#
case "$1" in
start)
if [ -f ${PGLOGFILE} ]
then
mv ${PGLOGFILE} ${PGLOGFILE}.old
touch ${PGLOGFILE}
fi
echo -n "Starting postgres: "
#
# force full login to get PGDATA and PGLIB path names
# Since the login script for ${PGACCOUNT} is SH/BASH compliant,
# we use proper redirection syntax...
#
if [ ${USE_SYSLOG} = "yes" ]; then
su - ${PGACCOUNT} -c "(${POSTMASTER} ${PGOPTS} 2>&1 | logger -p
${FACILITY}.notice) &" > /dev/null 2>&1 &
else
su - ${PGACCOUNT} -c '"${POSTMASTER} ${PGOPTS} &> ${PGLOGFILE} &" > /dev/null
2>&1 &'
fi
sleep 5
pid=`pidof ${POSTMASTER}`
echo -n "${POSTMASTER} [$pid]"
# touch /var/lock/subsys/${POSTMASTER}
echo
;;
stop)
echo -n "Stopping postgres: "
pid=`pidof ${POSTMASTER}`
if [ "$pid" != "" ] ; then
echo -n "${POSTMASTER} [$pid]"
kill -TERM $pid
sleep 1
fi
echo
;;
install)
echo "Adding postgres to runlevel system."
cp $0 /etc/rc.d/init.d/postgres
/sbin/chkconfig --add postgres
echo
;;
uninstall)
echo "Deleting postgres from runlevel system."
/sbin/chkconfig --del postgres
rm /etc/rc.d/init.d/postgres
echo
;;
*)
echo "Usage: $0 {start|stop|install|uninstall}"
exit 1
esac
exit 0
