Re: newbie question

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