From: | Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com> |
---|---|
To: | Atul Kumar <akumar14871(at)gmail(dot)com>, pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org> |
Subject: | Re: password error in batch script |
Date: | 2023-07-27 21:45:48 |
Message-ID: | d70dc834-0b13-df73-88ae-540a507a348c@aklaver.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On 7/27/23 1:17 PM, Atul Kumar wrote:
> Hi,
>
> I have a password Vl=SO*CIz%A83FQF that is working fine like that in the
> command prompt but when it is being used in a batch file it is giving me
> an error of wrong password, the password is something looks like that in
> batch script.
>
> set "PGPASSWORD=Vl=SO*CIz%A83FQF"
More information needed.
1) What sort of batch script; shell, Python, etc?
2) OS and version.
3) What is set pointing at?
4) PGPASSWORD is an environment variable per:
https://www.postgresql.org/docs/15/libpq-envars.html
So I would expect export PGPASSWORD = .
5) Why not use pgpass?:
https://www.postgresql.org/docs/current/libpq-pgpass.html
>
> Could you please help me in getting this password read by command prompt
> in the batch file.
>
>
>
> Regards.
--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com
From | Date | Subject | |
---|---|---|---|
Next Message | Amn Ojee Uw | 2023-07-28 00:19:27 | PostgreSQL - How to login with my Linux user account |
Previous Message | Charly | 2023-07-27 20:38:39 | Re: How to improve the performance of my SQL query? |