will the SIGUSR1 can wake up the latch(select in WaitLatch Fun)??
Plz Reply..
--
Thanks Regards,
Aaliya Zarrin
(+91)-9160665888
for the recovery to get stop?
Can I change this pg_is_in_recovery = 0?
--
Thanks Regards,
Aaliya Zarrin
(+91)-9160665888
...@gmail.com wrote:
On Fri, Dec 10, 2010 at 3:51 PM, aaliya zarrin aaliya.zar...@gmail.com
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
AND TELEPHONE CORPORATION
NTT Open Source Software Center
--
Thanks Regards,
Aaliya Zarrin
(+91)-9160665888
.
Though I've been thinking about this topic, a good idea doesn't occur to me
yet.
http://archives.postgresql.org/pgsql-hackers/2010-09/msg00929.php
Regards,
--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center
--
Thanks Regards,
Aaliya Zarrin
(+91
and 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 aaliya.zar...@gmail.com
Ok.. Thanks I will try!!!
2010/12/2 Heikki Linnakangas heikki.linnakan...@enterprisedb.com
Oh, and there's another value for the case we're polling the archive
Hi All,
I am new to postgres.
I want to know how frequently postgres search for trigger file to switch
over.
Can this switch over time be reduced?
Plz let me know where postgres poll for trigger file. I could find it out in
backend/access/trans/xlog.c ? am i right?
--
Thanks Regards,
Aaliya
:
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 branch, it's always 5 s.
Can this switch over time