dbTalk Databases Forums  

[NOVICE] problem with streaming replication

mailing.database.pgsql-novice mailing.database.pgsql-novice


Discuss [NOVICE] problem with streaming replication in the mailing.database.pgsql-novice forum.



Reply
 
Thread Tools Display Modes
  #1  
Old   
Caio Boiteux
 
Posts: n/a

Default [NOVICE] problem with streaming replication - 05-07-2012 , 11:28 AM






Hi
i tried to do streaming replication following the tutorial at
http://wiki.postgresql.org/wiki/Bina...ation_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


--
Sent via pgsql-novice mailing list (pgsql-novice (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Reply With Quote
  #2  
Old   
Caio Boiteux
 
Posts: n/a

Default Re: [NOVICE] problem with streaming replication - 05-07-2012 , 04:24 PM






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:
Quote:
Hi
i tried to do streaming replication following the tutorial at
http://wiki.postgresql.org/wiki/Bina...ation_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
--
Sent via pgsql-novice mailing list (pgsql-novice (AT) postgresql (DOT) org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-novice

Reply With Quote
Reply




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off



Powered by vBulletin Version 3.5.3
Copyright ©2000 - 2013, Jelsoft Enterprises Ltd.