Re: newbie question
От | Xue-Feng Yang |
---|---|
Тема | Re: newbie question |
Дата | |
Msg-id | 20010712030800.68864.qmail@web14602.mail.yahoo.com обсуждение исходный текст |
Ответ на | newbie question (Xue-Feng Yang <just4look@yahoo.com>) |
Ответы |
Re: newbie question
(Henry House <hajhouse@houseag.com>)
|
Список | pgsql-admin |
Thanks all. The problem is changed to [xyang@d141-67-217 xyang]$ psql -h localhost psql: Missing or erroneous pg_hba.conf file, see postmaster log for details Where are thses files? --- Henry House <hajhouse@houseag.com> wrote: > On Tue, Jul 10, 2001 at 11:24:26PM -0400, Xue-Feng > Yang wrote: > [...] > > Here is the file. Please give me more suggestions. > > Scroll down for the comments. > > > #! /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 > > The previous line (mangled by mailer word wrapping) > starts the postmaster. > Try changing it to: > > su -l postgres -c "/usr/bin/pg_ctl -D $PGDATA -p > /usr/bin/postmaster start -o "-i" >/dev/null 2>&1" < > /dev/null > > The -o "<options>" tells the pg_ctl utility to pass > the options in <options> > to the postmaster when starting it. There is a > manual page on pg_ctl; you may > find it useful. You can pass any options to the > postmaster, so you could make > it listed to any tcp port you like. > > > 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 > > ;; > === message truncated === > ATTACHMENT part 2 application/pgp-signature _______________________________________________________ Do You Yahoo!? Get your free @yahoo.ca address at http://mail.yahoo.ca
В списке pgsql-admin по дате отправления: