Thanks Magnus for the really fast response. Your inputs have helped removed my doubts. I now went back and checked my slave server and the WALs files are being shipped and the streaming replication is also working. I will try a PITR test this weekend...
I have set wal_keep_segments to 3 but maybe I will bump in to 30 or some such bigger number. On a related note, I am see the following log entries: 2012-08-14 11:28:34 IST LOG: streaming replication successfully connected to primary 2012-08-14 18:35:13 IST FATAL: could not receive data from WAL stream: SSL error: sslv3 alert unexpected message 2012-08-14 18:35:18,444 8691 INFO 000000010000002D0000002E: not found (ignored) 2012-08-14 18:35:18 IST LOG: record with zero length at 2D/2E488200 2012-08-14 18:35:18,551 8693 INFO 000000010000002D0000002E: not found (ignored) 2012-08-14 18:35:18 IST LOG: streaming replication successfully connected to primary 2012-08-16 12:56:07 IST FATAL: could not receive data from WAL stream: SSL error: sslv3 alert unexpected message 2012-08-16 12:56:13,086 8753 INFO 000000010000002D000000CB: not found (ignored) 2012-08-16 12:56:13 IST LOG: invalid magic number 0000 in log file 45, segment 203, offset 13246464 2012-08-16 12:56:13,192 8755 INFO 000000010000002D000000CB: not found (ignored) 2012-08-16 12:56:13 IST LOG: streaming replication successfully connected to primary My followup question is, do such errors affect the integrity of the slave? Is the slave in a consistent state after such errors occur? I notice that the corresponding WAL files are available on the slave though... -- View this message in context: http://postgresql.1045698.n5.nabble.com/You-cannot-do-PITR-with-streaming-replication-true-tp5720050p5720054.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