will the SIGUSR1 can wake up the latch(select in WaitLatch Fun)??
Plz Reply..
--
Thanks & Regards,
Aaliya Zarrin
(+91)-9160665888
recovery to get stop?
Can I change this pg_is_in_recovery = 0?
--
Thanks & Regards,
Aaliya Zarrin
(+91)-9160665888
Fri, Dec 10, 2010 at 3:51 PM, aaliya zarrin
> wrote:
> > Can anybody tell after finding the trigger file what steps does postgres
> > follow?
>
> The server applies all the WAL records available, performs checkpoint,
> renames recovery.conf, and gets out of recovery mode.
t;
> Thought?
>
> Regards,
>
> --
> Fujii Masao
> NIPPON TELEGRAPH AND TELEPHONE CORPORATION
> NTT Open Source Software Center
>
--
Thanks & Regards,
Aaliya Zarrin
(+91)-9160665888
I can not used SIGHUP, as it is already in use.
I want to wake up the postmaster once the trigger file is generated
and tell it to switch over from standby mode.
Is it possible?
On Wed, Dec 8, 2010 at 9:17 AM, Fujii Masao wrote:
> On Tue, Dec 7, 2010 at 4:22 PM, aaliya zarrin
> wrote:
SIGUSR2 are handled in the postmaster? is it
for the same?
If I handle my own signal using SIGUSR1/SIGUSR2 is it possible without
affecting the other functionality of existing code?
--
Thanks & Regards,
Aaliya Zarrin
(+91)-9160665888
Hey!1
I am able to change the switch over time.. Thanks alot..
2010/12/2 aaliya zarrin
> Ok.. Thanks I will try!!!
>
> 2010/12/2 Heikki Linnakangas
>
> Oh, and there's another value for the case we're polling the archive, not
>> streaming from master.
wrote:
> On 01.12.2010 13:27, aaliya zarrin wrote:
>
>> I want to know how frequently postgres search for trigger file to switch
>> over.
>>
>
> In 9.0, every 100ms while streaming replication is active and connected. 5
> seconds otherwise. In current git master b
& Regards,
Aaliya Zarrin
(+91)-9160665888
