Re: Postgres User Home ENV Help

I think you are trying to solve the wrong problem.

You should not be switching to user 'postgres' regularly enough that the
default bash shell bothers you. Instead, you should switch to user
'postgres' only when you need superuser access to create new roles,
permissions, databases, etc.

If you create a role that match your normal login, then you can run 'psql'
from your normal account, and you won't need to customize user postgres'
shell environment.

My two cents,
and my best regards,

Mike M

On Thu, Jun 20, 2013 at 2:13 PM, carlosinfl . <carlos(dot)mennens(at)gmail(dot)com>wrote:

> Can someone please help me set the 'postgres' users home ENV so that I
> can simply type 'psql' rather than the rull path and bash doesn't say
> '-bash-4.1$'?
>
> -bash-4.1$ whoami;ls -l;pwd
> postgres
>
> total 12
> drwx------ 2 postgres postgres 4096 Apr 4 18:33 backups
> drwx------ 15 postgres postgres 4096 Jun 18 20:52 data
> -rw------- 1 postgres postgres 1493 Jun 14 21:11 pgstartup.log
>
> /var/lib/pgsql9
>
> --
> Carlos Mennens
>
>
> --
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-novice
>