Re: newbie and no idea

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.
>
> [root(at)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(at)bzq-218-14-208 aamehl]#
> ---------------------------------------
> root(at)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(at)bzq-218-14-208 aamehl]#
>
> ----------------------------------------------------------------
> [root(at)bzq-218-14-208 aamehl]# createdb -U postgres nigun_test
> psql: FATAL: IDENT authentication failed for user "postgres"
>
> createdb: database creation failed
> [root(at)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
>