-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
IIRC, there is a postgres user, and you have to sign in as that user at some
point...but I think the biggest contribution I can make is this URL:
http://postgresql.crimelabs.net/users-lounge/docs/7.2/postgres/client-authentication.html
But I'm going through the docs and they aren't that helpful. Perhaps if you
asked on the Postgresql mailing list? (Warning: that list is fairly high
traffic!)
Russell
On Tuesday 04 June 2002 08:16 am, you wrote:
> 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
- --
Linux -- the OS for the Renaissance Man
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.0.6 (GNU/Linux)
Comment: For info see http://www.gnupg.org
iD8DBQE8/Lt8AqKGrvVshJQRAiFTAKCYL10MVYJbBmnKMLg4UiPWMkveogCfdA2I
v6B4+sNNam9YPuzFEIe2tYM=
=qmPg
-----END PGP SIGNATURE-----
This archive was generated by hypermail 2.1.3 : Fri Aug 01 2014 - 20:21:04 EDT