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.
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general