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

2017-07-21 Thread Thom Brown
On 19 July 2017 at 20:12, vstuart wrote: > 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 >

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

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

2017-07-20 Thread David G. Johnston
On Thu, Jul 20, 2017 at 8:37 AM, vstuart wrote: > ​​ > [victoria@victoria ~]$ pg > [sudo -u postgres -i] > [sudo] password for victoria: > ​Just curious, what is going on here? David J. ​

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*

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

2017-07-19 Thread David G. Johnston
On Wed, Jul 19, 2017 at 12:12 PM, vstuart wrote: > Hi David: I see what you are saying; sorry for the confusion. This is how > postgres operates on my system: > ​None of that is surprising or unique. If you ask specific questions I'd be willing to answer them but I'm

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

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

2017-07-19 Thread David G. Johnston
On Wed, Jul 19, 2017 at 11:49 AM, vstuart wrote: > As a simple solution, I can sudo symlink MY ~/.psqlrc to that directory > (/var/...; changing ownership also to postgres), but there appears to be > some underlying issue, as Pg should find ~/.psqlrc, correct? > ​What

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

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

2017-07-19 Thread Thom Brown
On 18 July 2017 at 19:02, vstuart wrote: > My ~/.psqlrc file is ignored by my PostgreSQL installation (v.9.6.3; Arch > Linux x86_64 platform). > > Suggestions? Do you get anything with "psql -a"? If not, what do you get when you use "psql -af ~/.psqlrc" ? Thom --

[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. --