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 w
On 03/21/2014 05:29 PM, john.tiger wrote:
thks for quick comments - see below:
On 03/21/2014 06:00 PM, Adrian Klaver wrote:
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 ro
On 03/21/2014 06:38 PM, john.tiger wrote:
On 03/21/2014 06:43 PM, Rodrigo Gonzalez wrote:
On 03/21/2014 09:29 PM, john.tiger wrote:
EDIT from @rodrigo
hmm, user postgres vs os postgres - okay understand what you mean but
how is this fixed ? or what is proper procedure ?
It depends on wh
On 03/21/2014 06:43 PM, Rodrigo Gonzalez wrote:
On 03/21/2014 09:29 PM, john.tiger wrote:
EDIT from @rodrigo
hmm, user postgres vs os postgres - okay understand what you mean but
how is this fixed ? or what is proper procedure ?
It depends on what you want to fix...
if you want to be abl
On 03/21/2014 09:29 PM, john.tiger wrote:
> EDIT from @rodrigo
>
> hmm, user postgres vs os postgres - okay understand what you mean but
> how is this fixed ? or what is proper procedure ?
>
It depends on what you want to fix...
if you want to be able to do su - postgres change its OS passwor
thks for quick comments - see below:
On 03/21/2014 06:00 PM, Adrian Klaver wrote:
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 => auth
On 03/21/2014 08: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
postgress or postgres?
The name is different, but in
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
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
hba.conf edited to allow "trust" to local - shouldn't this be set up as
standard default ?
still authent