On 03/21/2014 08:47 PM, john.tiger wrote: > 9.3 install on debian jessie 64amd > > sudo -u postgres psql => worked > alter user postgres with password 'password' => alter role > > su - postgress > enter password => authentication failure postgress or postgres? The name is different, but in case you made a typo here, with alter user you changed postgresql password for user postgres not for OS user postgres > > hba.conf edited to allow "trust" to local - shouldn't this be set up as > standard default ? Other people can give you different replies...for me...NO, security is first and trust is completely skipping security from my point of view > > still authentication failure (after rebooting) > > now sudo -u postgres psql => could not connect - is server running - > shouldn't install set up server to be booted on start up ? Is it running? I dont use debian, but something like service postgresql status can give you an idea... or, more general ps aux | grep postgres Best regards Rodrigo Gonzalez -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
