Thread: Error pg_standby 'pg_standby' is not recognized as an internal or external command!!

Hello everyone.
I'm using PostgreSQl 9.2 on the windows XP
in recovery.conf  use command


*standby_mode = 'on'
primary_conninfo = 'host=10.0.10.2 port=5432 user=postgres password =
password'
restore_command = 'copy \\\\10.0.10.2\\archiver\\%f %p'
restore_command = 'pg_standby -d -s 5 -t C:\pgsql.trigger.5442
\\\\10.0.10.2\\archiver\\%f %p %r 2>>standby.log'
recovery_end_command = 'del C:\pgsql.trigger.5442'*


and standby.log say

'pg_standby' is not recognized as an internal or external command, operable
program or batch file.

How to fix ?
Thank !




--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Error-pg-standby-pg-standby-is-not-recognized-as-an-internal-or-external-command-tp5780795.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

Tobadao wrote:
> Hello everyone.
> I'm using PostgreSQl 9.2 on the windows XP
> in recovery.conf  use command
> 
> 
> *standby_mode = 'on'
> primary_conninfo = 'host=10.0.10.2 port=5432 user=postgres password =
> password'
> restore_command = 'copy \\\\10.0.10.2\\archiver\\%f %p'
> restore_command = 'pg_standby -d -s 5 -t C:\pgsql.trigger.5442
> \\\\10.0.10.2\\archiver\\%f %p %r 2>>standby.log'
> recovery_end_command = 'del C:\pgsql.trigger.5442'*
> 
> 
> and standby.log say
> 
> 'pg_standby' is not recognized as an internal or external command, operable
> program or batch file.
> 
> How to fix ?

I don't really know much about Windows, but shouldn't it help if
the PATH environment variable of the PostgreSQL process contains the directory
that contains pg_standby.exe?

Yours,
Laurenz Albe