Re: conflict ? password authentication failed for user "postgres"

Subject: Re: conflict ? password authentication failed for user "postgres"

From: "David Tangye" <..hidden..>

Date: Wed, 12 Sep 2007 11:04:17 +1000

I have both sl and lsmb running. Here is my pg_hba.conf

#TYPE   DATABASE    USER        CIDR-ADDRESS          METHOD
local   all         postgres                          ident sameuser
local   all         sql-ledger                        trust
local   all         dt                                ident sameuser
local   all         all                               md5

host    all         sql-ledger 127.0.0.0/16          trust
host    all         dt          127.0.0.0/16          ident sameuser
host    all         all         127.0.0.0/16          md5

host    all         all         10.0.0.0/8            md5

host    all         all         192.168.0.0/16        md5

host    all         all         0.0.0.0/0             md5
host    all         all         ::1/128               md5

On 9/12/07, Joseph <..hidden..> wrote:

[snip]
>
>         This worked as well, next in order to login I had to change
>         file:
>         pg_hba.conf to:
>         local   all         all                               md5
>         # IPv4 local connections:
>         host    all         all         127.0.0.1/32        md5
>
>         at this point I can login but I can not create "dataset"
>         I think the password for "postgres" is getting encrypted where
>         as
>         originally it was set unencrypted.
>
>
> change the auth types back to trust for a moment.
> Then log in as postgres
> run the following command:
> ALTER USER postgres WITH PASSWORD '[secret]';
>
> Then change the auth types back to md5 (note that any change to the
> pg_hba.conf requires restarting PostgreSQL.
>
> Best Wishes,
> Chris Travers
>
How do I login as postgres, I've tried the following:

# su postgres
..hidden.. /etc/apache2 $ ALTER USER postgres WITH PASSWORD '[secret]';
bash: ALTER: command not found

$ psql -U postgres
psql: FATAL:  database "postgres" does not exist

--
#Joseph

-------------------------------------------------------------------------
This SF.net email is sponsored by: Microsoft
Defy all challenges. Microsoft(R) Visual Studio 2005.
http://clk.atdmt.com/MRT/go/vse0120000070mrt/direct/01/
_______________________________________________
Ledger-smb-users mailing list
..hidden..
https://lists.sourceforge.net/lists/listinfo/ledger-smb-users