Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] createdb problem

From: Larry Rosenman <ler(at)lerami(dot)lerctr(dot)org>
To: sprawlsr(at)worldnet(dot)att(dot)net (Robert J(dot) Sprawls)
Cc: pgsql-novice(at)postgreSQL(dot)org, pgsql-admin(at)postgreSQL(dot)org, pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [NOVICE] createdb problem
Date: 1999-11-14 19:37:08
Message-ID: 199911141937.dAEJb8414109@lerami.lerctr.org (view raw or flat)
Thread:
Lists: pgsql-bugs
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=(at)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(at)lerctr(dot)org
US Mail: 1905 Steamboat Springs Drive, Garland, TX 75044-6749

pgsql-bugs by date

Next:From: Chaotic InceptionsDate: 1999-11-14 21:03:04
Subject: Arrays of composites, bug or usage?
Previous:From: Larry RosenmanDate: 1999-11-14 19:32:40
Subject: Re: [NOVICE] createdb problem

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group