Not for the world have I been able to solve this one. What does initdb need
to determine a "valid username" and/or why is my Solaris box not assigning
an
"explicit username?" USER is set in the environment and whoami returns
"postgres" corectly. Or is it just some kind of problem finding the lib
files that I couldn't find in the FAQs?
Mike

$ initdb
ld.so.1: pg_id: fatal: libpq.so: open failed: No such file or directory
Unable to determine a valid username. If you are running
initdb without an explicit username specified, then there
may be a problem with finding the Postgres shared library
and/or the pg_id utility.

$ env
HOME=/usr/local/pgsql
HZ=100
LOGNAME=postgres
MAIL=/var/mail/postgres
MANPATH=:/usr/local/pgsql/man
PATH=/usr/bin::/usr/local/bin:/usr/local/pgsql/bin:/usr/ucb
PGDATA=/home/postgres
PGLIB=/usr/local/pgsql/lib
SHELL=/bin/sh
TERM=vt100
TZ=US/Eastern
USER=postgres

$ whoami
postgres

$ uname -a
SunOS oets6 5.6 Generic_105181-17 sun4m sparc SUNW,SPARCstation-5

$ grep postgres /etc/passwd /etc/group
/etc/passwd:postgres:x:30003:30003:postgress:/usr/local/pgsql:/bin/sh
/etc/group:postgres::30003:mdavis

$ ls -ladF /home/postgres /usr/local/pgsql
drwxrwxr-x 3 postgres postgres 512 Dec 2 11:38 /home/postgres/
drwxrwxr-x 7 postgres postgres 512 Dec 21 11:12 /usr/local/pgsql/

Search Discussions

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouppgsql-ports @
categoriespostgresql
postedDec 21, '99 at 8:30p
activeDec 21, '99 at 8:30p
posts1
users1
websitepostgresql.org
irc#postgresql

1 user in discussion

Michael R. Davis: 1 post

People

Translate

site design / logo © 2022 Grokbase