Re: 9.3 debian install setup failure

On 03/21/2014 04: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

So did you really type postgress (note extra s) or is this just an email
error?

>
> hba.conf edited to allow "trust" to local - shouldn't this be set up as
> standard default ?

This is a packager decision, in other words something Debian did.

>
> 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 ?

You would think. Are you sure it is not running? In other words have you
done a ps ax and looked to see if it is running. It could also be that
it running a listening on a different port. It would be helpful if you
showed the actual full error messages. The fragment you show above (if I
am assuming right) usually asks if the server is running and listening
on port XXXX

>
>
>
>
>

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com