Warm standby

I want to setup a form of replication for postgresql using the warm
standby option
(http://www.postgresql.org/docs/8.2/static/warm-standby.html)

I have had success to let server A to copy the WAL logs to server B (the
standby server).  But I have had no success on the recovery side of
things. I might just be overlooking something.  You help will be
appreciated.

I have the following in the /etc/postgresql/8.2/main/recovery.conf on
server B:

restore_command = '/var/lib/postgresql/8.2/main/restore.sh /var/lib/postgresql/8.2/main/wal/%f "%p"'

and  /var/lib/postgresql/8.2/main/restore.sh looks like this:


#!/bin/bash

RESTORE_FROM=$1
RESTORE_TO=$2
DELAY=100000
TRIGGERED=0
TRIGGER_FILE="/var/lib/postgresql/8.2/main/trigger"

copyfunc() {
if [ "$TRIGGERED" -eq "0" ]; then
    cp -v -i $RESTORE_FROM $RESTORE_TO
fi
}

k=`expr $1 : '.*\(history\)'`

if [ "$k" == "history" ]; then
copyfunc;
exit $?;
fi

while [ ! -f "$RESTORE_FROM" -a "$TRIGGERED" -eq "0" ]; do
        usleep $DELAY;
        if [ -e $TRIGGER_FILE ]; then
            TRIGGERED=1;
        fi
done

copyfunc;

This was adapted from a howto at
http://www.postgresql.org/docs/8.2/static/warm-standby.html

The content of /var/lib/postgresql/8.2/main/wal/ looks like this:

$ ls wal
000000010000000000000000  00000001000000000000000E  00000001000000000000001C
000000010000000000000001  00000001000000000000000F  00000001000000000000001D
000000010000000000000002  000000010000000000000010  00000001000000000000001E
000000010000000000000003  000000010000000000000011  00000001000000000000001F
000000010000000000000004  000000010000000000000012  000000010000000000000020
000000010000000000000005  000000010000000000000013  000000010000000000000021
000000010000000000000006  000000010000000000000014  000000010000000000000022
000000010000000000000007  000000010000000000000015  000000010000000000000023
000000010000000000000008  000000010000000000000016  000000010000000000000024
000000010000000000000009  000000010000000000000017  000000010000000000000025
00000001000000000000000A  000000010000000000000018  000000010000000000000026
00000001000000000000000B  000000010000000000000019  000000010000000000000027
00000001000000000000000C  00000001000000000000001A  000000010000000000000028
00000001000000000000000D  00000001000000000000001B


And the postgresql-log shows:



2007-02-26 15:58:54 SAST LOG:  database system was shut down at 2007-02-26 15:58:53 SAST
2007-02-26 15:58:54 SAST LOG:  checkpoint record is at 0/42C9BC
2007-02-26 15:58:54 SAST LOG:  redo record is at 0/42C9BC; undo record is at 0/0; shutdown TRUE
2007-02-26 15:58:54 SAST LOG:  next transaction ID: 0/1098; next OID: 16385
2007-02-26 15:58:54 SAST LOG:  next MultiXactId: 1; next MultiXactOffset: 0
2007-02-26 15:58:54 SAST LOG:  database system is ready
2007-02-26 15:58:55 SAST LOG:  incomplete startup packet

It does not seem to do anything about the WAL logs from the other
server.

What am I missing?

Regards
Johann
--
Johann Spies          Telefoon: 021-808 4036
Informasietegnologie, Universiteit van Stellenbosch

     "If we confess our sins, he is faithful and just to
      forgive us our sins, and to cleanse us from all
      unrighteousness."       I John 1:9