Re: Trying to use binary replication - from tutorial

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxxxxxxx> 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



[Index of Archives]     [KVM ARM]     [KVM ia64]     [KVM ppc]     [Virtualization Tools]     [Spice Development]     [Libvirt]     [Libvirt Users]     [Linux USB Devel]     [Linux Audio Users]     [Yosemite Questions]     [Linux Kernel]     [Linux SCSI]     [XFree86]

  Powered by Linux