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 <qa4...@motorola.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 <ewal...@decisionanalyst.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 >> > >
