On 1/15/26 10:22, pramod gupta wrote:
> postgres@ANRPGTEST01:~$ echo $HOME
> /var/lib/postgresql
> postgres@ANRPGTEST01:~$
I have to believe the extension author is referring to a user
/home/some_user/ directory.
How are you getting to postgres@ANRPGTEST01?
What happens if you try something like?:
sudo -u postgres psql -d postgres -U postgres
>
> On Thu, Jan 15, 2026 at 11:27 PM Adrian Klaver
> <adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>> wrote:
>
> On 1/15/26 09:48, pramod gupta wrote:
> Again, you need to use Reply All to get post to mailing list
> Ccinglist.
>
>
> You did not answer 2) or 3).
>
> Though the below is revealing:
>
> > postgres@ANRPGTEST01:~$ ls -ltrh /var/lib/postgresql/.pg_ai.config
> > -rw------- 1 postgres postgres 1.8K Jan 15 17:03 /var/lib/
> > postgresql/.pg_ai.config
> > postgres@ANRPGTEST01:~$ pwd
> > /var/lib/postgresql
> > postgres@ANRPGTEST01:~$ psql
> > psql (16.11 (Ubuntu 16.11-1.pgdg24.04+1))
> > Type "help" for help.
> >
> > postgres=# \q
>
> Per:
> https://github.com/benodiwal/pg_ai_query/issues/38 <https://
> github.com/benodiwal/pg_ai_query/issues/38>
>
> "
> benodiwal last month
>
>
> Thanks for sharing, actually .pg_ai.config should be in your home
> directory and not root. Can u try to put it in home directory once and
> they try.
>
> sudheermudunuri
>
> same with me as well i added in /var/lib/postgresql/.pg_ai.config but
> still it doesn't load from the config file.
>
> benodiwal
>
>
> Hey @sudheermudunuri, it is designed this way in first release. Can u
> please try putting it in home dir.
>
> "
>
> --
> Adrian Klaver
> adrian.klaver@aklaver.com <mailto:adrian.klaver@aklaver.com>
>
--
Adrian Klaver
adrian.klaver@aklaver.com
