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 mode.
Regards,
Hi ,
I want to stop the recovery forcefully what shall I do? Rather say,
after finding the trigger file I want postgres to switch over?
Which function shall I call?
Where the flow is transfer exactly after finding the trigger file?
On Fri, Dec 10, 2010 at 2:36 PM, Fujii Masao
On Wed, Dec 8, 2010 at 6:22 PM, Fujii Masao masao.fu...@gmail.com wrote:
On Wed, Dec 8, 2010 at 4:59 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
For 9.1, we should think of a better way to do this, perhaps using SIGUSR1
to wake up. Maybe we won't even need the trigger
Hi All,
Can anybody tell after finding the trigger file what steps does postgres
follow?
When and how it will set the postgres recovery mode to false?
On Thu, Dec 9, 2010 at 3:51 PM, Fujii Masao masao.fu...@gmail.com wrote:
On Wed, Dec 8, 2010 at 6:22 PM, Fujii Masao masao.fu...@gmail.com
On Wed, Dec 8, 2010 at 4:59 PM, Heikki Linnakangas
heikki.linnakan...@enterprisedb.com wrote:
For 9.1, we should think of a better way to do this, perhaps using SIGUSR1
to wake up. Maybe we won't even need the trigger file anymore.
If we use SIGUSR1, the mechanism to allow the users to specify
aaliya zarrin escreveu:
I want to signal the postmaster (User defined signal) once I created the
trigger file (for switch over).
Send a SIGHUP to postmaster. Have in mind that it doesn't work on all
supported platforms.
--
Euler Taveira de Oliveira
http://www.timbira.com/
--
Sent via
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 masao.fu...@gmail.com wrote:
On Tue, Dec 7, 2010 at 4:22 PM, aaliya
On 08.12.2010 06:12, aaliya zarrin wrote:
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?
SIGHUP works precisely because it is already in use. When you send
Hi,
I want to signal the postmaster (User defined signal) once I created the
trigger file (for switch over).
I want to reduce my switch over time further by signaling the postmaster
once the trigger file is created.
Is this provision already there in the code?
There ate already SIGUSR1 and