[prev in list] [next in list] [prev in thread] [next in thread]
List: postgresql-admin
Subject: Re: Starting Postgre DB in read write mode
From: Shreeyansh Dba <shreeyansh2014 () gmail ! com>
Date: 2018-01-18 9:56:27
Message-ID: CAGDYbUPmABFy=oZWUYr7mVunkhzo0cE0BsOcEZW09VWhA-wbMQ () mail ! gmail ! com
[Download RAW message or body]
[Attachment #2 (multipart/alternative)]
Hi Ashwani Kumar ,
To open slave server in read/write mode you can use below command.
*pg_ctl -D <your slave data directory> promote*
Hope this helps..
---
[image: http://www.shreeyansh.com] <http://www.shreeyansh.com/>
On Thu, Jan 18, 2018 at 3:01 PM, Ashwani Kumar B <
ashwani.b.kumar@ericsson.com> wrote:
> Hi
>
>
>
> Due to some upgrade activity, I break the master slave DB sync on two site.
>
>
>
> Now I want to start the DB of secondary site [Slave DB ] in read write
> mode so that I can update the DB manually. How can I do that as after break
> slave DB is working in read only mode.
>
>
>
>
>
> *Regards,*
>
> [image: Description: Description: Description: Description: line]
>
> *Ashwani Kumar*
> Ericsson India Global Services Private Limited
>
> [image: Description: Description:
> http://www.yourconferencecentre.com/ericsson/Brand/images/other/other_logo.gif]
> ashwani.b.kumar@ericsson.com
>
> Mobile : +91 9999771339
>
> Skype ID : Ashwani.k.07
> www.ericsson.com
>
>
>
[Attachment #5 (text/html)]
<div dir="ltr"><div class="gmail_default" style="font-size:small">Hi <span \
style="font-size:12.8px;white-space:nowrap">Ashwani Kumar ,<br><br>To open slave \
server in read/write mode you can use below command.<br><br><b>pg_ctl -D <your \
slave data directory> promote</b><br><br>Hope this helps..<br><br></span><div \
class="gmail_default" style="display:inline"></div>---<br><div \
class="gmail_signature"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div dir="ltr"><div \
dir="ltr"><a href="http://www.shreeyansh.com/" target="_blank" \
style="font-size:12.8px"><img \
src="https://docs.google.com/uc?export=download&id=0B0kMUYo6rsLZRXV4Qkxpa3ljNlE&revid=0B0kMUYo6rsLZWGxhS2NjRGlCanJkMWJuRzZqS09QWlRyTWxVPQ" \
alt="http://www.shreeyansh.com" width="200" \
height="124"></a></div></div></div></div></div></div></div></div></div></div></div><div \
class="gmail_extra"><br><div class="gmail_quote">On Thu, Jan 18, 2018 at 3:01 PM, \
Ashwani Kumar B <span dir="ltr"><<a href="mailto:ashwani.b.kumar@ericsson.com" \
target="_blank">ashwani.b.kumar@ericsson.com</a>></span> wrote:<br><blockquote \
class="gmail_quote" style="margin:0px 0px 0px 0.8ex;border-left:1px solid \
rgb(204,204,204);padding-left:1ex">
<div lang="EN-US">
<div class="gmail-m_-2777338570875071647WordSection1">
<p class="MsoNormal">Hi<u></u><u></u></p>
<p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Due to some upgrade activity, I break the master slave DB sync \
on two site.<u></u><u></u></p> <p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal">Now I want to start the DB of secondary site [Slave DB ] in read \
write mode so that I can update the DB manually. How can I do that as after break \
slave DB is working in read only mode.<u></u><u></u></p> <p class="MsoNormal"><u></u> \
<u></u></p> <p class="MsoNormal"><u></u> <u></u></p>
<p class="MsoNormal"><b><span style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(0,32,96)">Regards,<u></u><u></u></span></b></p> <p \
class="MsoNormal"><span style="font-size:10.5pt;color:rgb(0,32,96)"><img width="255" \
height="3" id="gmail-m_-2777338570875071647Picture_x0020_1" \
src="cid:image001.gif@01D3906D.42070E30" alt="Description: Description: Description: \
Description: line"></span><span \
style="font-size:10.5pt;color:rgb(0,32,96)"><u></u><u></u></span></p> <p \
class="MsoNormal"><b><span style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(51,51,51)">Ashwani Kumar</span></b><span \
style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(51,51,51)"> <b><br>
</b>Ericsson India Global Services Private Limited<u></u><u></u></span></p>
<p class="MsoNormal"><span style="font-size:10.5pt;color:rgb(31,73,125)"><img \
width="202" height="70" id="gmail-m_-2777338570875071647Picture_x0020_2" \
src="cid:image002.jpg@01D3906D.42070E30" alt="Description: Description: \
http://www.yourconferencecentre.com/ericsson/Brand/images/other/other_logo.gif"></span><span \
style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(51,51,51)"><br> </span><span \
style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(0,32,96)"><a href="mailto:ashwani.b.kumar@ericsson.com" \
target="_blank"><span style="color:blue">ashwani.b.kumar@ericsson.com</span></a> \
<u></u><u></u></span></p> <p class="MsoNormal"><span \
style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(0,32,96)">Mobile : +91 \
9999771339<u></u><u></u></span></p> <p class="MsoNormal"><span \
style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(0,32,96)">Skype ID : Ashwani.k.07</span><u><span \
style="font-size:10.5pt;font-family:"Book Antiqua",serif;color:navy"><br> \
</span></u><span style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(0,32,96)"><a href="http://www.ericsson.com/" \
target="_blank"><span style="color:blue">www.ericsson.com</span></a></span><span \
style="font-size:10.5pt;font-family:"Book \
Antiqua",serif;color:rgb(31,73,125)"><u></u><u></u></span></p> <p \
class="MsoNormal"><u></u> <u></u></p> </div>
</div>
</blockquote></div><br><br clear="all"><div><br></div><br>
</div></div>
--001a114f3228620149056309cfbd--
["image001.gif" (image/gif)]
["image002.jpg" (image/jpeg)]
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic