Re: problem with streaming replication

Sorry for replying to myself but I fixed the problem
it was a simple case of library mixup

if someone gets the same error
check your ld.so.conf for the directory(s) where the postgres librarys are
in my case I had both postgres 9.0 ands 9.1 instaled and the libs of the 9.0
version were geting selected for the 9.1 version
this resulted in a postgres that worked but couldn't do streaming replication

fixing the ld.so.conf order, fixed the error

thanks
    Caio Boiteux

On Monday 07 May 2012 13:28:23 you wrote:
> Hi
> i tried to do streaming replication following the tutorial at
> http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial
>
> but i stoped at a problem and cant find nothing in google
> when i start the slave server it starts ... and tels
> LOG:  database system was shut down in recovery at 2012-05-07 14:17:32 BRT
> LOG:  entering standby mode
> LOG:  restored log file "00000001000000000000006F" from archive
> LOG:  consistent recovery state reached at 0/6FDD9510
> LOG:  record with zero length at 0/6FDD9510
> LOG:  database system is ready to accept read only connections
> FATAL:  could not start WAL streaming: unexpected response from server;
> first received character was "W"
>
>
> the last line repeats ad eternum ...
> i tried to search for it in google but no luck
> my postgres in master is 9.1.2
> and in slave is 9.1.3
>
> I understood that this kind of version mismatch was supported, am i wrong ?
>
> thanks a lot
>     Caio Boiteux