From: | Xue-Feng Yang <just4look(at)yahoo(dot)com> |
---|---|
To: | Henry House <hajhouse(at)houseag(dot)com> |
Cc: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: newbie question |
Date: | 2001-07-11 03:24:26 |
Message-ID: | 20010711032426.26933.qmail@web14601.mail.yahoo.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
--- Henry House <hajhouse(at)houseag(dot)com> wrote:
> On Tue, Jul 10, 2001 at 10:02:03PM -0400, Xue-Feng
> Yang wrote:
> > Sounds that the postmaster does not listen on TCP.
> > How can I add it to TCP?
>
> You need to pass the -i switch to the postmaster
> when starting it. Most
> likely your distribution provided an initscript
> (/etc/init.d/postgresql
> perhaps) to start and stop the postmaster; if so you
> will need to edit this
> file.
>
> --
> Henry House
> OpenPGP key available from
> http://romana.hajhouse.org/hajhouse.asc
>
> ATTACHMENT part 2 application/pgp-signature
Here is the file. Please give me more suggestions.
#! /bin/sh
# postgresql This is the init script for starting
up the PostgreSQL
# server
# Version 6.5.3-2 Lamar Owen
# Added code to determine if PGDATA exists, whether it
is current version
# or not, and initdb if no PGDATA (initdb will not
overwrite a database).
# Version 7.0 Lamar Owen
# Added logging code
# Changed PGDATA.
#
# Version 7.0.2 Trond Eivind Glomsrd <teg(at)redhat(dot)com>
# use functions, add conditional restart
# chkconfig: 345 85 15
# description: Starts and stops the PostgreSQL backend
daemon that handles \
# all database requests.
# processname: postmaster
# pidfile: /var/run/postmaster.pid
#
# Source function library.
. /etc/rc.d/init.d/functions
# Get config.
. /etc/sysconfig/network
# Check that networking is up.
# Pretty much need it for postmaster.
[ ${NETWORKING} = "no" ] && exit 0
[ -f /usr/bin/postmaster ] || exit 0
start(){
PSQL_CHECK="Checking postgresql installation:
"
PSQL_START="Starting postgresql service: "
echo -n "$PSQL_CHECK"
# Check for older PGDATA location.
if [ -f /var/lib/pgsql/PG_VERSION ] && [ -d
/var/lib/pgsql/base/template
1 ]
then
export PGDATA=/var/lib/pgsql
else
export PGDATA=/var/lib/pgsql/data
fi
# Check for the PGDATA structure
if [ -f $PGDATA/PG_VERSION ] && [ -d
$PGDATA/base/template1 ]
then
# Check version of existing PGDATA
if [ `cat $PGDATA/PG_VERSION` != '7.0'
]
then
echo
echo "old version. Need to
Upgrade."
echo "See
/usr/share/doc/postgresql-7.0.2/README.rpm for
more information."
exit 1
else
success "$PSQL_CHECK"
echo
fi
# No existing PGDATA! Initdb it.
else
echo "no database files found."
if [ ! -d $PGDATA ]
then
mkdir -p $PGDATA
chown postgres.postgres
$PGDATA
fi
su -l postgres -c '/usr/bin/initdb
--pglib=/usr/lib/pgsql --pgda
ta=/var/lib/pgsql/data' < /dev/null
fi
# Check for postmaster already running...
pid=`pidof postmaster`
if [ $pid ]
then
echo "Postmaster already running."
else
#all systems go -- remove any stale
lock files
rm -f /tmp/.s.PGSQL.* > /dev/null
echo -n "$PSQL_START"
su -l postgres -c "/usr/bin/pg_ctl -D
$PGDATA -p /usr/bin/postm
aster start >/dev/null 2>&1" < /dev/null
sleep 1
pid=`pidof postmaster`
if [ $pid ]
then
success "$PSQL_START"
touch
/var/lock/subsys/postgresql
echo $pid >
/var/run/postmaster.pid
echo
else
failure "$PSQL_START"
echo
fi
fi
}
stop(){
echo -n "Stopping postgresql service: "
killproc postmaster
sleep 2
rm -f /var/run/postmaster.pid
rm -f /var/lock/subsys/postgresql
echo
}
restart(){
stop
start
}
condrestart(){
[ -e /var/lock/subsys/postgresql ] && restart || :
}
# This script is slightly unusual in that the name of
the daemon (postmaster)
# is not the same as the name of the subsystem
(postgresql)
# See how we were called.
case "$1" in
start)
start
;;
stop)
stop
;;
status)
status postmaster
;;
restart)
restart
;;
condrestart)
condrestart
;;
*)
echo "Usage: postgresql
{start|stop|status|restart|condrestart}"
exit 1
esac
exit 0
_______________________________________________________
Do You Yahoo!?
Get your free @yahoo.ca address at http://mail.yahoo.ca
From | Date | Subject | |
---|---|---|---|
Next Message | Justin Clift | 2001-07-11 03:32:10 | Re: Performance tuning for linux, 1GB RAM, dual CPU? |
Previous Message | Henry House | 2001-07-11 01:50:25 | Re: newbie question |