Thanks for all suggestions. based on the constraints I had with network, I
could able to set up the warm stand by. I am seeing the following log file
I don't know to how to handle.
2013-10-03 17:52:00 GMT [27636]: [457-1] user=,db=LOG: restored log file
"000101F60003" from archive
sc
On Tue, Oct 1, 2013 at 10:48 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova wrote:
>
>> but it would be a good idea to set hot_standby_feedback to on and
>> max_standby_archive_delay to something larger than 30s
>
> Doesn't replica need a connection to master for hot_
On Tue, Oct 1, 2013 at 5:30 PM, akp geek wrote:
> I tried tunneling this morning and it did not work. when tried the tunneling
> command in the url you mentioned getting following error. I will try to find
> what exactly this mean , but any help is appreciated.
>
> command-line: line 0: Bad config
On Tue, Oct 1, 2013 at 6:15 PM, Jaime Casanova wrote:
> you don't need to use streaming replication for a hot standby, it
> works perfectly well even if you replay everything from archive and
> never do streaming.
Right, I mixed up a with the terms a bit.
> but it would be a good idea to set hot
On Tue, Oct 1, 2013 at 5:46 PM, Sergey Konoplev wrote:
> On Tue, Oct 1, 2013 at 2:03 PM, akp geek wrote:
>> One more thing.. pardon me for being dumb
>>
>> I want to set the 2 nd slave as HOT STAND BY, not steaming ..
>
> Hot standby assumes being streaming. You can not establish a hot
> standb
thanks. I can try this. Any idea for the message below. Thanks for the
patience
I tried tunneling this morning and it did not work. when tried the
tunneling command in the url you mentioned getting following error. I will
try to find what exactly this mean , but any help is appreciated.
command-l
On Tue, Oct 1, 2013 at 2:03 PM, akp geek wrote:
> One more thing.. pardon me for being dumb
>
> I want to set the 2 nd slave as HOT STAND BY, not steaming ..
Hot standby assumes being streaming. You can not establish a hot
standby without using streaming replication. What is the reason not to
d
One more thing.. pardon me for being dumb
I want to set the 2 nd slave as HOT STAND BY, not steaming ..
What would be steps.
on the primary I will have the archive_command
on the slave in the recover.conf , restore_command.
After I make my slave as exactly as master, How can the slave gets
it is a firewall issue. they can't open the port that we requested it.
so as you mentioned tunnel to the primary via tunnel. will give that a try
regards
On Mon, Sep 30, 2013 at 11:10 PM, Chris Travers wrote:
>
>
>
> On Mon, Sep 30, 2013 at 7:14 PM, akp geek wrote:
>
>> Hi all -
>>
>>
On Mon, Sep 30, 2013 at 7:14 PM, akp geek wrote:
> Hi all -
>
> Currently we have set up one master one slave , which working
> fine. Now we need to replicate to an other slave. The problem we have ,
> the port that we use on primary can not be reached from the new slave. We
> can't t
10 matches
Mail list logo
