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

Re: Trying to use binary replication - from tutorial

From: Evan Walter <ewalter(at)decisionanalyst(dot)com>
To: Mark Keisler <qa4437(at)motorola(dot)com>
Cc: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: Trying to use binary replication - from tutorial
Date: 2011-10-13 20:31:28
Message-ID: CAOHVLOF0Wxp+u1XZ5KR78q3c_80ut8Xe1knikFw0NGiqH2pf3w@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-adminpgsql-general
I pretty much didn't change anything in the config files except what was in
the tutorial at http://wiki.postgresql.org/wiki/Binary_Replication_Tutorial

on the slave I created a recovery.conf file containing:
standby_mode = 'on'
primary_conninfo = 'host=<servers ip here>'

on the master postgresql.conf I set
listen_address = '*'
wav_level = hot_standby
max_wal_senders = 3

I didn't change any of postgresql.conf Archiving settings.  They all seem to
be commented out.  Could that be the problem?

Evan


On Thu, Oct 13, 2011 at 3:19 PM, Mark Keisler <qa4437(at)motorola(dot)com> wrote:

> Do not rsync the pg_xlog.  Basically that error means that the
> restore_command in your recovery.conf is not working.  You have hot_standby
> archiving going on the master and a recovery_command on the slave, right?
>
>
>
> On Thu, Oct 13, 2011 at 10:41 AM, Evan Walter <ewalter(at)decisionanalyst(dot)com
> > wrote:
>
>>
>>
>> Hello,
>> I am somewhat new with postgresql trying to find a good method of
>> replication for my company.
>> I am running through the tutorials on binary replication for postgresql
>> 9.1.  Both servers are virtual box Ubuntu 10.10 on a laptop.
>>
>> I ran this rsync -av --exclude pg_xlog --exclude postgresql.conf
>> /var/lib/postgresql/9.1/main/* postgres:<ip-address of
>> standby>:/var/lib/postgresql/9.1/main/
>>
>> The standby server then will not restart.  It says it is missing
>> pg_xlog/0000000000 ...   files
>>
>> I ran the rsync again not excluding the pg_xlog.  This time both servers
>> restart but there doesn't seem to be any replication occurring.
>>
>> I am curious why this is going on - why it didn't work excluding the
>> pg_xlog.  Was there something wrong with my syntax?  Is there something I am
>> missing not found in the tutorial?
>> I will appreciate any help, advice.
>>
>> Thank you,
>>
>> Evan
>>
>
>

In response to

Responses

pgsql-admin by date

Next:From: Vishnu S.Date: 2011-10-14 05:27:06
Subject: Tablespace issue
Previous:From: Mark KeislerDate: 2011-10-13 20:19:59
Subject: Re: Trying to use binary replication - from tutorial

pgsql-general by date

Next:From: Robert FitzpatrickDate: 2011-10-13 20:39:19
Subject: Test for cascade delete in plpgsql
Previous:From: Mark KeislerDate: 2011-10-13 20:19:59
Subject: Re: Trying to use binary replication - from tutorial

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