Re: Cannot get a backup using a script

Be certain you change APPDATA back like it was – that’s a HUGE problem in a windows server.

Writes,

Ken Benson | Director, Development | InfoWerks Data Services, Inc. | 817.253.7867 (direct) | infowerks.com<http://infowerks.com/>

From: pgsql-novice-owner(at)postgresql(dot)org [mailto:pgsql-novice-owner(at)postgresql(dot)org] On Behalf Of JORGE MALDONADO
Sent: Thursday, November 26, 2015 8:30 AM
To: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: [NOVICE] Cannot get a backup using a script

My BIG mistake !!!
Yes, the content of "pgpass.conf" file was "localhot" instead of "localhost". The script has run successfully.

I appreciate the effort of all of you who kindly invested your valuable time helping me.

Respectfully,
Jorge Maldonado

On Thu, Nov 26, 2015 at 10:24 AM, Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at<mailto: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

> 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.

You should not change APPDATA; this is set by the Windows operating system.

This environment variable changes depending on who is logged on.

Does PostgreSQL run as "Administrator" user? I hope not.

You will have to find out the value of APPDATA for the PostgreSQL user and
place pgpass.conf in %APPDATA%\postgresql of that user.

If you are confused, ask a Windows system administrator.

Yours,
Laurenz Albe