You can try If you know root's password, 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. > > [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] aamehl]# > --------------------------------------- > [EMAIL PROTECTED] 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 > [EMAIL PROTECTED] aamehl]# > > ---------------------------------------------------------------- > [EMAIL PROTECTED] aamehl]# createdb -U postgres nigun_test > psql: FATAL: IDENT authentication failed for user "postgres" > > createdb: database creation failed > [EMAIL PROTECTED] 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 > ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
