On Mon, Jun 03, 2002 at 08:56:19PM -0400, Jeff Barriault wrote:
> I'm having a little trouble installing PostgreSQL on RedHat 7.3 and was
> hoping someone could help. Basically, I've installed the RPMs from the CD
> without any problems. I've also installed the latest Webmin RPM from
> http://www.webmin.com. I can start the postgresql service from the Bootup
> and Shutdown menu in Webmin, but can't seem to get any further than that.
>
> When I select PostgreSQL Database Server from the Servers tab in Webmin, it
> asks me for an administration logon and password. I have no idea what to
> enter in this dialog box. Whatever I seem to try returns "Login failed:
> incorrect administation username or password"
>
> I'm sure I'm missing something here in the setup of things. I've read a few
> books and manuals, but can't find anything on installing from RedHat RPMs
> and using Webmin. Any help would be appreciated.
>
I don't know anything about using PostgreSQL with Webmin, but this is
what I've discovered in starting PostgreSQL on various machines for the
first time. (Pardon if you already know some of this; others may not.)
PostgreSQL keeps track of its own administrator and users, though those
users are users on the underlying Linux OS. The administrator for
PostgreSQL is generally something like "postgres" (see /etc/passwd to
find what it is on your system-- it should stand out in the file). If
you try to log in as that user, you cannot, because no password has been
set on a virgin system for it. So you have to run:
passwd postgres
and supply a password. Once you've done this, you can log in as the
postgres user, and run PostgreSQL's createuser program. I normally issue
this as:
createuser -d paulf
which allows me (a plain old user) to create databases. After that, I
never have to run as the postgres user again.
Sorry if I haven't provided a kewl GUI way to do this, but this is how I
do it. In addition, someone else may know some easier way to do this.
What I've given you is based in trial and error, and experience.
Paul
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:19:48 EDT