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@xxxxxxxxxxx -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
