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
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 the change the primary port also, because many applications usi
11 matches
Mail list logo
