0

I installed the "pgAgent 3.2.1-1" tool from "Stack Builder 3.1.0" in Windows 8.1 64 bit with “PostgreSQL 9.1.4-1”, I have created a job:

The result of the job execution is

Status: Failed Result: 1 Output: Could not get a connection to the database!

Please help me guys!

Santhucool
  • 1,656
  • 2
  • 36
  • 92

1 Answers1

1

The file .pgpass in a user's home directory is a file that can contain passwords to be used if the connection requires a password (and no password has been specified otherwise). On Microsoft Windows the file is named %APPDATA%\postgresql\pgpass.conf (where %APPDATA% refers to the Application Data subdirectory in the user's profile). Add the password and Database Schema username inside it and save it. Restart the pgsql service it works!!

Santhucool
  • 1,656
  • 2
  • 36
  • 92