Re: authentication failure - Mailing list pgsql-general

From Sameer Kumar
Subject Re: authentication failure
Date
Msg-id CADp-Sm5q9e+W5XV0_at4V8JYg412=4FDSj_MXrPUcAqBLOsXzQ@mail.gmail.com
Whole thread Raw
In response to Re: authentication failure  (Jayadevan M <maymala.jayadevan@gmail.com>)
Responses Re: authentication failure
List pgsql-general

On Sat, Jan 4, 2014 at 1:29 PM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:
There is only one instance -

 ps -eaf | grep bin/postgres | grep -v grep
postgres  3203     1  0  2013 ?        00:02:04 /usr/pgsql-9.3/bin/postgres

This only tells that there is one instance running!

There could be multiple PostgreSQL installations. And I guess that is what Tom meant here.

Can you try 
$ which psql
$ which pg_clt 

Can you set your $PGUSER variable to postgres and then try?

$ export $PGUSER=postgres



Best Regards,
Sameer Kumar | Database Consultant
ASHNIK PTE. LTD.
101 Cecil Street, #11-11 Tong Eng Building, Singapore 069533
M : +65 8110 0350 T: +65 6438 3504 | www.ashnik.com
www.facebook.com/ashnikbiz | www.twitter.com/ashnikbiz

email patch

This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).

Attachment

pgsql-general by date:

Previous
From:
Date:
Subject: help interpreting pg_stat_user_index view values
Next
From: Jayadevan
Date:
Subject: Re: authentication failure