postgresql - pgAgent scheduled job failed on Windows -


i trying set step batch file path on particular time in pgagent via pgadmin. when run failing , in step statistics got output

c:\windows\system32>c:\postgresql\run.bat 'psql' not recognized internal or external command, operable program or batch file.

details:

postgresql 9.3.5 on local system account (current user) pgadmin 1.18.1 pgagent via stack builder administrator account (current user) 

in run.bat have 2 statement

@echo off psql -h localhost -p 5433 -u postgres -d test -a -f "test.sql" 

i have psql in system path variable , able access in cmd. when run bat file manually executing without fail. when given batch file path (c:\postgresql\run.bat) in pgagent jobs giving error in statistics.

is there wrong in configuration? why going c:\windows\system32>?

edit:

my run.bat file

 @echo off  set lbsdatabasename=test set dbhost=localhost  set dbport=5434  set dbuser=postgres  set logfile=dbinstall.log  set sqlfolder="d:\sourcecode\archivescripts"          "c:\program files (x86)\postgresql\9.3\bin\psql.exe" -h "%dbhost%" -p "%dbport%" -d "%lbsdatabasename%" -u "%dbuser%" -l "%logfile%" -q -f "%sqlfolder%\archive.sql" 

my archive.sql

update "archive".emp set "firstname"='srikanth dyapa'; 

for example,

d:\pgagent_jobs

is path psql located.

d:\pgagent_jobs\scripts\test.sql

is path in test.sql placed.

d:\pgagent_jobs\scripts\psqlss.bat

is bat file execute test.sql

so bat file below

 @echo off  cd /d d:\\pgagent_jobs  psql -h localhost -p 5432 -u postgres -d db_name -a -f "d:\pgagent_jobs\scripts\test.sql" 

note : pg_hba.conf configured trust hosts that's why not passing password in above psql command


Comments

Popular posts from this blog

php - Submit Form Data without Reloading page -

linux - Rails running on virtual machine in Windows -

php - $params->set Array between square bracket -