| From: | Allan Kamau <kamauallan(at)gmail(dot)com> |
|---|---|
| To: | Postgres General Postgres General <pgsql-general(at)postgresql(dot)org> |
| Subject: | Preventing psql from attempting to access ~/.pgpass file. |
| Date: | 2017-10-17 06:06:59 |
| Message-ID: | CAF3N6oTr4J51x-QsfsDLv0wxQuJf_s-jVh82Zw=VJnV=U3nevQ@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hi,
I am executing many "COPY" commands via psql serially from a bash script
from a compute node that accesses a mounted home directory located on a
remote server.
After about a thousand or so executions of the "COPY" command I get the
error "psql: could not get home directory to locate password file".
for each subsequent attempt to connect to PostgreSQL using psql so as to
issue the next "COPY" command.
I have configured pg_hba.conf to trust connections coming from the specific
network which contains both the PostgreSQL server and the node which I am
executing the psql commands from.
Is there a way to instruct psql not to try reading ~/.pgpass file?
Both server and client (psql) are PostgreSQL 10.0 built from source, the OS
environment is Linux Centos 7.3.1611 (Core).
Allan.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas Kellerer | 2017-10-17 06:11:38 | Re: Making subscribers read only in Postgres 10 logical replication |
| Previous Message | Feike Steenbergen | 2017-10-17 06:01:02 | Re: Making subscribers read only in Postgres 10 logical replication |