Date: Wed, 30 Sep 2015 10:38:04 -0500 Subject: [NOVICE] Backup failed using pg_dump from command promt From: jorgemal1960@gmail.com To: pgsql-novice@postgresql.org
Hi,
I have a DB in a Windows Server 2008 R2 and I want to automate the backup process using a batch file with a script which should run based on a task in the Task Scheduler. The dump command is as follows:
Also, I have included the password information in the pgpass.conf file located at c:\Users\UserName\AppData\Roaming\postgresql folder with the following format:
localhost:5432:dbName:userName:password
If I manually run the batch file that contains the script I get a message saying that "the connection to the database failed: fe_sendauth: no password supplied".