Thread: Re: [NOVICE] createdb problem

Re: [NOVICE] createdb problem

From
Larry Rosenman
Date:
Just to prove stuff here is the latest:

 $ su - postgres
Password:

$ env
_=/bin/env
TZ=:US/Central
PATH=/usr/bin:/usr/ccs/bin:/usr/ccs/bin:/usr/local/pgsql/bin
XKEYBOARD=C/US
LANG=C
LOGNAME=postgres
LD_LIBRARY_PATH=:/usr/local/pgsql/lib
HZ=
PGLIB=/usr/local/pgsql/lib
MANPATH=:/usr/local/pgsql/man
XNLSPATH=/usr/X/lib/Xsi/C/US
XMODIFIERS=@im=Local
NUMLOCK=no
KEYBOARD=C/US
PWD=/usr/local/pgsql
MAPCHAN=/usr/lib/mapchan/88591.dk
SHIFTDOWN=yes
HOME=/usr/local/pgsql
PGDATA=/usr/local/pgsql/data
TERMCAP=/etc/termcap
_TTYNAME=/dev/pts011
TERM=dtterm
_AST_FEATURES=UNIVERSE - att
$ postmaster -i &
[1]     2863
$ psql template1
No pg_hba.conf entry for host localhost, user postgres, database template1
Connection to database 'template1' failed.
No pg_hba.conf entry for host localhost, user postgres, database template1
$ tail -3 $PGDATA/pg_hba.conf

local        all                                         trust
host         all         127.0.0.1     255.255.255.255   trust
$


And here is the *WORKING* startup on the 2.1.2 box:

#!/bin/sh

case "$1" in
'start')

    PGDATA=/usr/local/pgsql/data;export PGDATA
    PGLIB=/usr/local/pgsql/lib;export PGLIB
    LD_LIBRARY_PATH=/usr/local/pgsql/lib;export LD_LIBRARY_PATH
        su postgres -c "cd /usr/local/pgsql/;nohup /usr/local/pgsql/bin/postmaster -i >>pgsql.log 2>&1 & "
        exit 0
        ;;

'stop')
    ;;
*)
        echo "Usage: $0 { start | stop }"
        ;;
esac

Robert J. Sprawls wrote:
>
>
> On Sun, 14 Nov 1999, Larry Rosenman wrote:
>
> > Here ya go:
> >
> > $ su - postmaster
> > UX:su: ERROR: Unknown user id: postmaster
> > $ su - postgres
> > Password:
> >
> > $ postmaster -i &
> > [1]     18803
> > $ psql
> > No pg_hba.conf entry for host localhost, user postgres, database postgres
> > Connection to database 'postgres' failed.
> > No pg_hba.conf entry for host localhost, user postgres, database postgres
>
> Ya need a few more options in there. Here is how I have mine startup on
> Slackware Linux:
>
> # Start up the PostgreSQL postmaster
> echo "Starting postmaster..."
> su postgres -c "/usr/local/pgsql/bin/postmaster -i -S -D /usr/local/pgsql/data"
>
> Also, did you define the environment variable PGDATA and the others?
>
> Robert
>
>
>
> ************
>


--
Larry Rosenman                      http://www.lerctr.org/~ler
Phone: +1 972-414-9812 (voice) Internet: ler@lerctr.org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749