[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: [ADMIN] PG 9.0 Replcation
From: "Rangi, Jai" <jrangi () automotive ! com>
Date: 2011-03-31 23:16:30
Message-ID: 11F808DFED68574E8357241F5B39CAF5B972C7 () mail-001 ! corp ! automotive ! com
[Download RAW message or body]
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
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"><head><meta http-equiv=Content-Type \
content="text/html; charset=us-ascii"><meta name=Generator content="Microsoft Word 12 \
(filtered medium)"><style><!-- /* Font Definitions */
@font-face
{font-family:"Cambria Math";
panose-1:2 4 5 3 5 4 6 3 2 4;}
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
pre
{mso-style-priority:99;
mso-style-link:"HTML Preformatted Char";
margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:"Courier New";}
p.MsoListParagraph, li.MsoListParagraph, div.MsoListParagraph
{mso-style-priority:34;
margin-top:0in;
margin-right:0in;
margin-bottom:0in;
margin-left:.5in;
margin-bottom:.0001pt;
font-size:11.0pt;
font-family:"Calibri","sans-serif";}
span.EmailStyle17
{mso-style-type:personal-compose;
font-family:"Calibri","sans-serif";
color:windowtext;}
span.HTMLPreformattedChar
{mso-style-name:"HTML Preformatted Char";
mso-style-priority:99;
mso-style-link:"HTML Preformatted";
font-family:"Courier New";}
.MsoChpDefault
{mso-style-type:export-only;}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
/* List Definitions */
@list l0
{mso-list-id:1284921550;
mso-list-type:hybrid;
mso-list-template-ids:-94238922 67698703 67698713 67698715 67698703 67698713 \
67698715 67698703 67698713 67698715;} @list l0:level1
{mso-level-tab-stop:none;
mso-level-number-position:left;
text-indent:-.25in;}
ol
{margin-bottom:0in;}
ul
{margin-bottom:0in;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]--></head><body lang=EN-US link=blue vlink=purple><div \
class=WordSection1><p class=MsoNormal>All,<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>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. \
<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p \
class=MsoListParagraph style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if \
!supportLists]><span style='mso-list:Ignore'>1.<span style='font:7.0pt "Times New \
Roman"'> </span></span><![endif]>Very Large wal \
log size. Specially archiving WAL is bigger pain. In our env, the Archive are almost \
70GB in 1 day. <br>What is the rule of thumb. How old WAL files one should archive in \
normal production evn. <o:p></o:p></p><p class=MsoListParagraph \
style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span \
style='mso-list:Ignore'>2.<span style='font:7.0pt "Times New \
Roman"'> </span></span><![endif]>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. <br>How can I stop the replication without \
stopping the slave DB Server etc. <o:p></o:p></p><p class=MsoListParagraph \
style='text-indent:-.25in;mso-list:l0 level1 lfo1'><![if !supportLists]><span \
style='mso-list:Ignore'>3.<span style='font:7.0pt "Times New \
Roman"'> </span></span><![endif]>Say I stop slave \
for few hours. How can I find how far behind is slave as compare to master. \
<o:p></o:p></p><p class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>These are \
few I have been wondering about, I am sure there will be more soon. <o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>If you guys an share you \
experience, that will be big good resource for many like me.<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p class=MsoNormal>-Jai<o:p></o:p></p><p \
class=MsoNormal><o:p> </o:p></p><p \
class=MsoNormal><o:p> </o:p></p></div></body></html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic