Search Postgresql Archives

Re: WAL Streaming Failure PostgreSQL 9.4

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

 




On May 28, 2015 9:58 AM, "Ivann Ruiz" <ivann.jprog@xxxxxxxxx> wrote:

> When I execute pg_ctl start on my standby I get the following
>
> LOG:  database system was interrupted; last known up at 2015-05-27 14:16:41 EDT
> LOG:  entering standby mode
> LOG:  restored log file "000000010000000000000028" from archive
> LOG:  redo starts at 0/28000090
> LOG:  consistent recovery state reached at 0/280000B8
> LOG:  unexpected pageaddr 0/24000000 in log segment 000000010000000000000029, offset 0
> LOG:  started streaming WAL from primary at 0/29000000 on timeline 1
>
> And on my master I have
>
> LOG:  database system was shut down at 2015-05-27 16:00:14 EDT
> LOG:  database system is ready to accept connections
> LOG:  autovacuum launcher started
>
> And then nothing else happens, please I really need help with this, I appreciate all comments. Any questions, please feel free to ask.

Are you applying any load to master?  If not, nothing needs to be replicated so there is nothing to happen.  If this is just for testing, run pgbench -T 3600.

Cheers, Jeff


[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