Search Postgresql Archives

Re: You cannot do PITR with streaming replication - true?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux