[GENERAL] ~/.psqlrc file is ignored

2017-07-19 Thread vstuart
My ~/.psqlrc file is ignored by my PostgreSQL installation (v.9.6.3; Arch Linux x86_64 platform). Suggestions? -- View this message in context: http://www.postgresql-archive.org/psqlrc-file-is-ignored-tp5971773.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. --

Re: [GENERAL] ~/.psqlrc file is ignored

2017-07-19 Thread vstuart
Hi Thom: thank you for your reply; I can't figure this one out! Per your reply: [victoria@victoria ~]$ pg [sudo -u postgres -i] [sudo] password for victoria: [postgres@victoria ~]$ psql -a psql (9.6.3) Type "help" for help. postgres=# \q [postgres@victoria ~]$ psql -af ~/.psqlrc /var

Re: [GENERAL] ~/.psqlrc file is ignored

2017-07-19 Thread vstuart
Hi David: I see what you are saying; sorry for the confusion. This is how postgres operates on my system: [victoria@victoria ~]$ echo $HOME /home/victoria [victoria@victoria ~]$ which postgres /usr/bin/postgres [victoria@victoria ~]$ postgres postgres does not know where to find the serve

Re: [GENERAL] ~/.psqlrc file is ignored [solved: $HOME/.psqlrc]

2017-07-20 Thread vstuart
'Solution,' for anyone else encountering this issue (Arch Linux PostgreSQL install ...). TLDR: symlink ~/.psqlrc to postgres $HOME/.psqlrc - [victoria@victoria ~]$ echo $HOME /home/victoria [victoria@victoria ~]$ ls -la .psq* -rw-r--r

Re: [GENERAL] ~/.psqlrc file is ignored [solved: $HOME/.psqlrc]

2017-07-20 Thread vstuart
~/.bashrc alias: alias pg='echo " [sudo -u postgres -i]" && sudo -u postgres -i' -- View this message in context: http://www.postgresql-archive.org/psqlrc-file-is-ignored-tp5971773p5972153.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general