On Sat, Jan 4, 2014 at 1:29 PM, Jayadevan M <maymala.jayadevan@xxxxxxxxx> 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
This email may contain confidential, privileged or copyright material and is solely for the use of the intended recipient(s).