[GENERAL] Trying to use binary replication - from tutorial

2011-10-13 Thread Evan Walter
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

Re: [GENERAL] [ADMIN] Trying to use binary replication - from tutorial

2011-10-13 Thread Evan Walter
Yes, sorry. Type Evan On Thu, Oct 13, 2011 at 12:20 PM, Scott Marlowe wrote: > On Thu, Oct 13, 2011 at 9:41 AM, Evan Walter > wrote: > > > > > > Hello, > > I am somewhat new with postgresql trying to find a good method of > > replication for my company. &g

Re: [GENERAL] [ADMIN] Trying to use binary replication - from tutorial

2011-10-13 Thread Evan Walter
ot 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 > wrote: >

Re: [GENERAL] [ADMIN] Trying to use binary replication - from tutorial

2011-10-17 Thread Evan Walter
recovery.conf (this was actually figured out by a colleague), the replication was working beautifully. Thanks Evan Walter On Mon, Oct 17, 2011 at 10:20 AM, Mark Keisler wrote: > In your recovery.conf, you should also have a restore_command setting. > That's what the standby postgres will use