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

Post a Comment

Popular posts from this blog

ruby - How do I merge two hashes into a hash of arrays? -

http://codepad.org/wmyzqlis i'd merge these 2 arrays: a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } into hash looks this: {:a => ["a", "1"], :b => ["b", "b"], :c => [nil, "c"], :d => ["d", nil] } this doesn't work: p a.merge(b) { |k, v1, v2| [v1, v2] } # {:c=>"c", :a=>["a", "1"], :b=>["b", "b"], :d=>"d"} it's because hash#merge call block duplicate keys. a = { :a => 'a', :b => 'b', :d => 'd' } b = { :a => '1', :b => 'b', :c => 'c' } hash[(a.keys|b.keys).map { |key| [key, [a.fetch(key, nil), b.fetch(key, nil)]] }] # => {:a=>["a", "1"], :b=>["b", "b"], :d=>["d", nil], :c=>...
Read more

c++ - Do gcc's __float128 floating point numbers take the current rounding mode into account? -

do arithmetic operations on gcc's __float128 floating point numbers take current rounding mode account? for instance, if using c++11 function std::fesetenv , change rounding mode fe_downward , results of arithmetic operations on __float128 rounded down? is guaranteed __float128 specification? i believe guaranteed operations on __float128 take rounding mode account. according gnu c library documentation floating-point calculations respect rounding mode. according gcc manual __float128 floating type supports arithmetic operations division etc. from deduce, operations on __float128 , rounding mode has be taken account. the gnu c library documentation states: 20.6 rounding modes floating-point calculations carried out internally precision, , rounded fit destination type. ensures results precise input data. ieee 754 defines 4 possible rounding modes: [...] reference: http://www.gnu.org/software/libc/manual/html_node/rounding.html ...
Read more