Thanks Paul. I went ahead and added a password but now I think something
else is wrong. When I look under the Red Hat User Manager (slick gui) I see
user 'postgres' with a Primary Group of 'postgres', Full Name of 'PostgreSQL
Server', Login Shell of '/bin/bash' and Home Directory of '/var/lib/pgsql'.
>From a terminal window I can change the password without any problems. When
I execute the command 'su postgres' I am not asked for a password and end up
with a prompt that looks like 'bash-2.05a$ '. Of course I'm not really sure
what I'm supposed to have, but I'd at least think it should have prompted me
for a password.
-----Original Message-----
From: slug@lists.nks.net [mailto:slug@lists.nks.net]On Behalf Of Paul M
Foster
Sent: Monday, June 03, 2002 10:02 PM
To: slug@nks.net
Subject: Re: [SLUG] HELP: Installing PostgreSQL on RedHat 7.3
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:20:50 EDT