Re: newbie question - Mailing list pgsql-admin

From Xue-Feng Yang
Subject Re: newbie question
Date
Msg-id 20010711032426.26933.qmail@web14601.mail.yahoo.com
Whole thread Raw
In response to newbie question  (Xue-Feng Yang <just4look@yahoo.com>)
Responses RE: newbie question
List pgsql-admin
--- Henry House <hajhouse@houseag.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 Glomsr�d <teg@redhat.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

pgsql-admin by date:

Previous
From: Henry House
Date:
Subject: Re: newbie question
Next
From: "Mahesh Guleria"
Date:
Subject: Can we increase the no. of users in postgres