Thanks
That works
Aaron
On Tue, 2003-08-19 at 00:07, Andrew L. Gould wrote:
> On Monday 18 August 2003 01:41 pm, Aaron wrote:
> > On Mon, 2003-08-18 at 21:25, Pavel Stehule wrote:
> > > You can try
> > >
> > > If you know root's password,
> >
> > I just installed postgres from rpm and I didn't add passwords. I
> > certainly don't know the postgres root password...
> >
> > maybe I should reinstall postgres??
> > Aaron
>
> By the looks of your command line prompts, "[root(at)bzq-218-14-208 aamehl]#",
> you are already logged in as root. Root doesn't need to know another user's
> password to change it -- just change it:
>
> [root(at)bzq-218-14-208 aamehl]# passwd postgres
>
> You will then be prompted for the new password.
>
> Also, root doesn't need a password to become another user:
>
> [root(at)bzq-218-14-208 aamehl]# su postgres
>
> Although this sounds great, this kind of power justifies the creation of a
> regular (not a superuser) user account for routine use, especially if you are
> a newbie.
>
> Best of luck,
>
> Andrew Gould