Re: [GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Patrick B
2016-09-20 16:46 GMT+12:00 Michael Paquier : > On Tue, Sep 20, 2016 at 1:30 PM, Patrick B > wrote: > > 2016-09-20 15:14 GMT+12:00 Venkata B Nagothi : > >> Do you mean to say that the WAL file "0002179A00F8" is > >> available @ "/var/lib/pgsql/9.2/archive" location ? > > > > Yes! > > T

Re: [GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Michael Paquier
On Tue, Sep 20, 2016 at 1:30 PM, Patrick B wrote: > 2016-09-20 15:14 GMT+12:00 Venkata B Nagothi : >> Do you mean to say that the WAL file "0002179A00F8" is >> available @ "/var/lib/pgsql/9.2/archive" location ? > > Yes! Timeline 2 has visibly reached its end at segment 000217

Re: [GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Patrick B
2016-09-20 15:14 GMT+12:00 Venkata B Nagothi : > > On Tue, Sep 20, 2016 at 12:38 PM, Patrick B > wrote: > >> Hi guys, >> >> I got a slave server running Postgres 9.2 with streaming replication and >> wal_archive in an EC2 Instance at Amazon. >> >> Postgres logs are showing me this error: >> >>> r

Re: [GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Lucas Possamai
2016-09-20 16:29 GMT+12:00 Lucas Possamai : > > > 2016-09-20 15:14 GMT+12:00 Venkata B Nagothi : > >> >> On Tue, Sep 20, 2016 at 12:38 PM, Patrick B >> wrote: >> >>> Hi guys, >>> >>> I got a slave server running Postgres 9.2 with streaming replication and >>> wal_archive in an EC2 Instance at Ama

Re: [GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Lucas Possamai
2016-09-20 15:14 GMT+12:00 Venkata B Nagothi : > > On Tue, Sep 20, 2016 at 12:38 PM, Patrick B > wrote: > >> Hi guys, >> >> I got a slave server running Postgres 9.2 with streaming replication and >> wal_archive in an EC2 Instance at Amazon. >> >> Postgres logs are showing me this error: >> >>> r

Re: [GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Venkata B Nagothi
On Tue, Sep 20, 2016 at 12:38 PM, Patrick B wrote: > Hi guys, > > I got a slave server running Postgres 9.2 with streaming replication and > wal_archive in an EC2 Instance at Amazon. > > Postgres logs are showing me this error: > >> restored log file "0002179A00F8" from archive >> inv

[GENERAL] FATAL: could not receive data from WAL stream

2016-09-19 Thread Patrick B
Hi guys, I got a slave server running Postgres 9.2 with streaming replication and wal_archive in an EC2 Instance at Amazon. Postgres logs are showing me this error: > restored log file "0002179A00F8" from archive > invalid record length at 179A/F8FFF3D0 > WAL segment `/var/lib/pgsql/