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 <[email protected] <mailto:[email protected]>> 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
    [email protected] <mailto:[email protected]>



--
Adrian Klaver
[email protected]


Reply via email to