PG 9.0 Replcation

From: "Rangi, Jai" <jrangi(at)automotive(dot)com>
To: <pgsql-admin(at)postgresql(dot)org>
Subject: PG 9.0 Replcation
Date: 2011-03-31 23:16:30
Message-ID: 11F808DFED68574E8357241F5B39CAF5B972C7@mail-001.corp.automotive.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

All,

I have PG 9.03 setup with master slave native replication. Everything
seems to be fine. I have few question or concerns. Coming from MySql
background, so trying to setup my expectations for PG.

1. Very Large wal log size. Specially archiving WAL is bigger
pain. In our env, the Archive are almost 70GB in 1 day.
What is the rule of thumb. How old WAL files one should archive in
normal production evn.

2. In mySQL there are some commands to start, stop slave, Show
slave status, See the exact position of Slave and Master, view how far
slave is behind master. In PG I see only pg_last_xlog_replay_location()
and pg_last_xlog_receive_location(). Don't know what those hexadecimal
codes means.
How can I stop the replication without stopping the slave DB Server
etc.

3. Say I stop slave for few hours. How can I find how far behind
is slave as compare to master.

These are few I have been wondering about, I am sure there will be more
soon.

If you guys an share you experience, that will be big good resource for
many like me.

-Jai

Browse pgsql-admin by date

  From Date Subject
Next Message Selva manickaraja 2011-04-01 00:37:57 Too many WAL(s) despite low transaction
Previous Message Steve Crawford 2011-03-31 20:57:56 Re: Freebsd/Postgres/Apache+PHP