Skip site navigation (1) Skip section navigation (2)

Re: problem with streaming replication

From: Caio Boiteux <caio(at)arras(dot)com(dot)br>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: problem with streaming replication
Date: 2012-05-07 21:24:31
Message-ID: 201205071824.31651.caio@arras.com.br (view raw or flat)
Thread:
Lists: pgsql-novice
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

In response to

pgsql-novice by date

Next:From: Bastiaan OlijDate: 2012-05-08 02:40:42
Subject: Finding out what authentication was used for the connected session
Previous:From: Caio BoiteuxDate: 2012-05-07 16:28:23
Subject: problem with streaming replication

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group