[I read the FAQ, which helped me to get started. This is my first attempt to
use an SQL-like data base. This is all on Redhat Linux 5.1, which has
postgres installed by default.]
* postmaster is now running and as postgres user. (Confirmed)
* initdb requires specs for PGLIB (RH5.1: /usr/lib), PGDATA (RH5.1:
/tmp/somedir/pgsql).
initdb --username=ivo
creates a bunch of stuff, primarily the "template1" database in
/tmp/somedir/pgsql/
* psql (as does initdb or anything else) still complains:
psql -d template1
Connection to database template1 failed
FATAL 1: SetUserId: user "[username]" is not in pg_shadow
Just looking at /tmp/somedir/pgsql/pg_shadow tells me that within this binary
file, [username] is somewhere in it, but without being able to connect, there
does not seem much that I know how to do.
This is probably obvious to anyone who is familiar with it, but neither the
tutorial nor the faq seem to cover this problem. Any help would be
appreciated. (Please cc or email directly to me.)
Sincerely,
/ivo welch
--
Ivo Welch mailto:ivo.welch@anderson.ucla.edu
UCLA http://linux.agsm.ucla.edu/
*** International Directory of Financial Economists ***
http://linux.agsm.ucla.edu/dir/