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
>
~/.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
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.
'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*
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
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
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
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
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
--
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.
--
10 matches
Mail list logo