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.