Trying to use binary replication - from tutorial

From: Evan Walter <ewalter(at)decisionanalyst(dot)com>
To: pgsql-admin(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Trying to use binary replication - from tutorial
Date: 2011-10-13 15:41:32
Message-ID: CAOHVLOEaVTtdi2ySpDmvtxhBpmTaBN9JUhDg1cpGqhvzbDn8ZA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin pgsql-general

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

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Scott Marlowe 2011-10-13 17:20:22 Re: Trying to use binary replication - from tutorial
Previous Message Vishnu S. 2011-10-13 12:37:17 The possibilities of dropping a table space

Browse pgsql-general by date

  From Date Subject
Next Message Merlin Moncure 2011-10-13 16:59:01 Re: could not reattach to shared memory
Previous Message unclebob 2011-10-13 15:22:51 Re: I need to load mysql dump to postgres...