| 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: | Whole Thread | Raw Message | 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
| 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 |
| 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... |