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: (view raw, whole thread or download thread mbox)
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 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 order, fixed the error

	Caio Boiteux

On Monday 07 May 2012 13:28:23 you wrote:
> Hi
> i tried to do streaming replication following the tutorial at
> 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-2017 The PostgreSQL Global Development Group