I have two identical Cent OS 5.3 computers configured identically with Postgresql 8.3.7. I'm trying to create a warm standby using WAL following the instructions at:
Both servers have access to the directory /path/to/archive
I configured postgresql.conf on the master server with:
archive_mode = on
archive_command = 'cp "%p" /path/to/archive/"%f"'
arvhice_timeout = 300
Then restarted postgresql. Then I logged into the database "psql db" and created the base backup "SELECT pg_start_backup('label');"
After that was done, I issued the "SELECT pg_stop_backup();" command. This created the backup file in "/path/to/archive".
Then on the slave postgresql server, I shut down the database, and created the recovery.conf file with
restore_command = 'cp /path/to/archive/%f %p'
When I try to restart postgresql on the slave, I get an error. What am I doing wrong?