[GeoNode-users] need help resetting psql geonode password

[Paolo Corti]

On Thu, Jul 30, 2015 at 12:39 AM, Charles Cossé <ccosse at gmail.com> wrote:
> Hi, I'm trying to set the password for user=geonode via:
>
> psql -c "alter role geonode with password 'mypasswd';"
>
> but it complains:  psql: FATAL:  Peer authentication failed for user "super"
>
> (or whoever i'm logged in as in my shell)
>
> "super" is the superuser I created during setup ... and if I use the "-U
> super -w" flags it prompts for a password but doesn't accept the one I have
> set.  I'm sure this is basic and i'm just tired but i'm stumped at the
> moment ...
>

This is related to the PostgreSQL authentication methods configured by
default in PostgreSQL settings.
Login as the postgres user in the shell and it should work.
p

-- 
Paolo Corti
Geospatial software developer
web: http://www.paolocorti.net
twitter: @capooti
skype: capooti