Creating a user fails

From: "Werner Schalk" <werner_schalk(at)gmx(dot)de>
To: <pgsql-general(at)postgresql(dot)org>
Subject: Creating a user fails
Date: 2002-06-22 17:11:43
Message-ID: 001701c21a0f$e23ceb30$0200a8c0@bertisevil
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,

I'm new to postgresql and tried
to install the dbms. I did a
"./configure --prefix=/usr/local/postgresql-7.2.1 \
--enable-nls=de --with-perl", "make"
and of course "make install".
I created a new user using the
command "useradd -g postgres -d \
/var/lib/postgres -s /bin/bash postgres",
created the directories /var/lib/postgres
and /var/lib/postgres/data, made a chown
(chown -R postgres /var/lib/postgres) on
them and sent a "initdb". This all works
fine and I can even start the database.
I also created a file .bash_profile which
looks like this:

PGBASE=/usr/local/postgresql-7.2.1
PGDATA=/var/lib/postgres/data
PGLIB=$PGBASE/lib
PGBIN=$PGBASE/bin
PGUSER=postgres

PATH=$PATH:$PGBIN

export PATH

export PGDATA PGLIB PGUSER

When I try to create a user I get the
message

postgres(at)diebels:~$ createuser -D -A -P werner
env: /usr/lib/postgresql/bin/readpgenv: No such file or directory
Could not execv /usr/lib/postgresql/bin/createuser

Why the hell is he trying to use /usr/lib/postgresql and
not the one I gave to ./configure? I mean I even
don't find a file called readpgenv??? What's wrong
here?

Thanks a lot in advice!
Werner

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Alvaro Herrera 2002-06-22 17:22:01 Re: clustered indexes?
Previous Message Oskar Berggren 2002-06-22 15:58:28 SQL server application porting headache