On 24.05.2011 18:27, manish singh wrote:
When ever i am restarting postgresql slave (Service postgresql restart -
made a script) or even just stopping and starting a postgresql slave.. it
displays a a message, although slave get's started and working fine...
server starting
cp: cannot stat
`/usr/local/pgsql/data/pg_xlogarch/000000010000000300000026': No such file
or directory
cp: cannot stat
`/usr/local/postgres/data/pg_xlogarch/000000010000000300000026': No such
file or directory
The standby server periodically checks if new WAL has arrived by
executing the restore_command. Your restore_command uses 'cp', which
prints out that message if the target file can't be found.
In other words, your system seems to be working correctly, and those
messages are harmless. You could silence it by replacing plain 'cp' with
a shell script that checks if the file exists first and calls 'cp' only
if it does.
--
Heikki Linnakangas
EnterpriseDB http://www.enterprisedb.com
--
Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-bugs
