Re: Cannot get a backup using a script

Thanks for your kind response.
I wrote "Username" only to show that a user name must be provided. It is
actually the administrator of the domain.

If I issue the "echo %APPDATA%" command I get
"c:\Users\Administrator\AppData\Roaming".

I tested issuing the following command:
SET PGPASSFILE="C:\Users\Administrator\AppData\Roaming\postgresql\
pgpass.conf"
And then "echo %APPDATA%" again, and I still get
"c:\Users\Administrator\AppData\Roaming"
Is there any relation between these 2 commands?

Another test I did was to SET APPDATA="C:\Users\Adminstrator\
AppData\Roaming\postgresql\pgpass.conf"
After this, I did "echo %APPDATA%" and I get the correct path. Then I issue
pg_dump but I still get the same error message.

Best regards,
Jorge Maldonado

On Thu, Nov 26, 2015 at 3:13 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
wrote:

> JORGE MALDONADO wrote:
> > I have been trying to get automated backups of a PostgreSQL database
> using a script without success.
> > The error I get is "fe_sendauth: no password supplied".
> >
> > I have a pgpass.conf in
> "C:\Users\Username\AppData\Roaming\postgresql\pgpass.conf" with the correct
> > information: localhot:5432:dbname:postgres:mypassword
>
> Is this "Username" literally?
>
> What do you get for "echo %APPDATA%"?
>
> The path should be %APPDATA%\postgresql\pgpass.conf
>
> Yours,
> Laurenz Albe
>