Re: 9.3 debian install setup failure - Mailing list pgsql-general

From Adrian Klaver
Subject Re: 9.3 debian install setup failure
Date
Msg-id 532CD2BB.1000206@aklaver.com
Whole thread Raw
In response to 9.3 debian install setup failure  ("john.tiger" <john.tigernassau@gmail.com>)
Responses Re: 9.3 debian install setup failure  ("john.tiger" <john.tigernassau@gmail.com>)
List pgsql-general
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


pgsql-general by date:

Previous
From: "john.tiger"
Date:
Subject: 9.3 debian install setup failure
Next
From: Rodrigo Gonzalez
Date:
Subject: Re: 9.3 debian install setup failure