Re: newbie and no idea

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

> you don't need set postgresql's password. But
> if you don't known root password, you can't change password for postgres
> user (for change of password you can use passwd command).
>
>
> su root
> su postgres
> createuser aamehl
> logout
> logout
> createdb  nigun_test
>
> bye
> Pavel Stehule
>
>
> On 18 Aug 2003, Aaron wrote:
>
> > A friend of mine just wrote a database for me using postgres.
> > I have postgres installed but can't figure out how to change the passwd
> > for user postgres.
> >
> > [root@bzq-218-14-208 aamehl]# ps -U postgres
> >   PID TTY          TIME CMD
> >  4014 pts/1    00:00:00 postmaster
> >  4016 pts/1    00:00:00 postmaster
> >  4017 pts/1    00:00:00 postmaster
> > [root@bzq-218-14-208 aamehl]#
> > ---------------------------------------
> > root@bzq-218-14-208 aamehl]# ps -l -C postmaster
> > F S   UID   PID  PPID  C PRI  NI ADDR    SZ WCHAN  TTY          TIME CMD
> > 0 S    26  4014     1  0  72   0    -  2446 do_sel pts/1    00:00:00
> > postmaster
> > 1 S    26  4016  4014  0  72   0    -  2693 do_sel pts/1    00:00:00
> > postmaster
> > 1 S    26  4017  4016  0  72   0    -  2451 do_sel pts/1    00:00:00
> > postmaster
> > [root@bzq-218-14-208 aamehl]#
> >
> > ----------------------------------------------------------------
> > [root@bzq-218-14-208 aamehl]# createdb -U postgres nigun_test
> > psql: FATAL:  IDENT authentication failed for user "postgres"
> >
> > createdb: database creation failed
> > [root@bzq-218-14-208 aamehl]#
> >
> > -----------------------------------------------------
> > Any idea??
> > I am also interested in getting some front end up and running.
> > Thanks
> > Aaron
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 5: Have you checked our extensive FAQ?
> >
> >                http://www.postgresql.org/docs/faqs/FAQ.html
> >
>