Re: Cannot get a backup using a script

2015-11-26 13:28 GMT-02:00 JORGE MALDONADO <jorgemal1960(at)gmail(dot)com>:

> 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
>>
>
>
Good afternoon Jorge,

Can you show us the backup script?

BR