On Fri, Mar 21, 2014 at 05:47:54PM -0600, john.tiger wrote: > 9.3 install on debian jessie 64amd Firstly, you did read: /usr/share/doc/postgresql-9.3/README.Debian.gz right? > sudo -u postgres psql => worked > alter user postgres with password 'password' => alter role Why on earth would you want to do that. The default is peer, so you don't need a password to login as the postgres user. > su - postgress > enter password => authentication failure > > hba.conf edited to allow "trust" to local - shouldn't this be set > up as standard default ? Did you not read the comment above it saying you should change that if you expect the default maintainence scripts to keep working? > 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 ? Check if the server is actually running with ps. Maybe you typoed the config file? Have a nice day, -- Martijn van Oosterhout <kleptog@xxxxxxxxx> http://svana.org/kleptog/ > He who writes carelessly confesses thereby at the very outset that he does > not attach much importance to his own thoughts. -- Arthur Schopenhauer
Attachment:
signature.asc
Description: Digital signature
