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 wrote:
> On Fri, De
On 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.
Regards,
--
Fujii Masao
NIPPON
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 wrote:
> On Wed, Dec 8, 2010 at 6:22 PM, Fujii Masao wrote:
> > On Wed, Dec 8, 2010 at 4:59 PM, H
On Wed, Dec 8, 2010 at 6:22 PM, Fujii Masao wrote:
> On Wed, Dec 8, 2010 at 4:59 PM, Heikki Linnakangas
> 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
On Wed, Dec 8, 2010 at 4:59 PM, Heikki Linnakangas
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 the event type
seems to be require
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
SIGHUP,
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:
> > Is
On Tue, Dec 7, 2010 at 4:22 PM, aaliya zarrin wrote:
> Is this provision already there in the code?
> There ate already SIGUSR1 and SIGUSR2 are handled in the postmaster? is it
> for the same?
SIGUSR1 is already used. SIGUSR2 is actually unused, but reserved for children
according to the source c
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 v
