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


--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

Reply via email to