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.klaver@aklaver.com