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
From: pgsql-novice-owner@postgresql.org [mailto:pgsql-novice-owner@postgresql.org] On Behalf Of JORGE MALDONADO Sent: Thursday, November 26, 2015 8:30 AM To: Albe Laurenz <laurenz.albe@wien.gv.at> Cc: pgsql-novice@postgresql.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.
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.