Postgres Pro
Downloads
Home   >   mailing lists

Thread: Startup Process Initiated by init proc (Unix)

Startup Process Initiated by init proc (Unix)

From
aaliya zarrin
Date:
Hi All,
 
I am new to postgres. I am using 9.0.1 of postgres.
I am using Switch over functionality of Postgres and want to reduce the switch over time.
I have implemented this using Signaling. After signaling the postmaster (startup process) once the trigger file is created and making PG to check for trigger file
and do the switch over. PG is receiving the signal and doing the switch over as well but two startup processes are running on standby node one initiated by postmested and other by init (unix process).
 
The steps I am following are as follows,
 - search for trigger file.
- Complete the recovery- rename recovery.conf file.
any step is missing I am not sure.
Pls Help.
I apologize if I am addressing to wrong mailing list. Pls suggest the correct mailing list if anybody know as well.
 
Thanks in advance.


--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888

Re: Startup Process Initiated by init proc (Unix)

From
Fujii Masao
Date:
On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
> I am new to postgres. I am using 9.0.1 of postgres.
> I am using Switch over functionality of Postgres and want to reduce the
> switch over time.
> I have implemented this using Signaling. After signaling the postmaster
> (startup process) once the trigger file is created and making PG to check
> for trigger file
> and do the switch over. PG is receiving the signal and doing the switch over
> as well but two startup processes are running on standby node one initiated
> by postmested and other by init (unix process).
>
> The steps I am following are as follows,
>  - search for trigger file.
> - Complete the recovery- rename recovery.conf file.
> any step is missing I am not sure.

The backtrace of that orphan process would be helpful for the analysis.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Re: Startup Process Initiated by init proc (Unix)

From
aaliya zarrin
Date:
I didn't get? Do you want the syslog files or some more information?

On Tue, Dec 28, 2010 at 11:32 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
> I am new to postgres. I am using 9.0.1 of postgres.
> I am using Switch over functionality of Postgres and want to reduce the
> switch over time.
> I have implemented this using Signaling. After signaling the postmaster
> (startup process) once the trigger file is created and making PG to check
> for trigger file
> and do the switch over. PG is receiving the signal and doing the switch over
> as well but two startup processes are running on standby node one initiated
> by postmested and other by init (unix process).
>
> The steps I am following are as follows,
>  - search for trigger file.
> - Complete the recovery- rename recovery.conf file.
> any step is missing I am not sure.

The backtrace of that orphan process would be helpful for the analysis.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888

Re: Startup Process Initiated by init proc (Unix)

From
Fujii Masao
Date:
On Tue, Dec 28, 2010 at 3:07 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
> I didn't get? Do you want the syslog files or some more information?

Yeah, I want more information. You can get the backtrace by using gdb.
In detail, please see the following:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center

Re: Startup Process Initiated by init proc (Unix)

From
aaliya zarrin
Date:
Sorry, My application is using the postgres DB but the another application is giving the command to run in standby or active mode.
I can't use gdb I beleive.
Can you suggest any other way.

On Tue, Dec 28, 2010 at 12:18 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
On Tue, Dec 28, 2010 at 3:07 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
> I didn't get? Do you want the syslog files or some more information?

Yeah, I want more information. You can get the backtrace by using gdb.
In detail, please see the following:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888

Re: Startup Process Initiated by init proc (Unix)

From
John R Pierce
Date:
On 12/27/10 11:00 PM, aaliya zarrin wrote:
> Sorry, My application is using the postgres DB but the another
> application is giving the command to run in standby or active mode.
> I can't use gdb I beleive.

gdb just needs the PID of the process to attach to, you can get that
from ps or via other methods.


http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD#Attaching_gdb_to_the_backend

Re: Startup Process Initiated by init proc (Unix)

From
aaliya zarrin
Date:
I can tell the changes I have done in the code if you want.

On Tue, Dec 28, 2010 at 12:30 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
Sorry, My application is using the postgres DB but the another application is giving the command to run in standby or active mode.
I can't use gdb I beleive.
Can you suggest any other way.

On Tue, Dec 28, 2010 at 12:18 PM, Fujii Masao <masao.fujii@gmail.com> wrote:
On Tue, Dec 28, 2010 at 3:07 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
> I didn't get? Do you want the syslog files or some more information?

Yeah, I want more information. You can get the backtrace by using gdb.
In detail, please see the following:
http://wiki.postgresql.org/wiki/Getting_a_stack_trace_of_a_running_PostgreSQL_backend_on_Linux/BSD

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888



--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888

Re: Startup Process Initiated by init proc (Unix)

From
aaliya zarrin
Date:
Hi,
I am unable to run the postgres using gdb.
I am getting error as " no debugging symbols found".
How to proceed?

On Tue, Dec 28, 2010 at 11:32 AM, Fujii Masao <masao.fujii@gmail.com> wrote:
On Tue, Dec 28, 2010 at 2:24 PM, aaliya zarrin <aaliya.zarrin@gmail.com> wrote:
> I am new to postgres. I am using 9.0.1 of postgres.
> I am using Switch over functionality of Postgres and want to reduce the
> switch over time.
> I have implemented this using Signaling. After signaling the postmaster
> (startup process) once the trigger file is created and making PG to check
> for trigger file
> and do the switch over. PG is receiving the signal and doing the switch over
> as well but two startup processes are running on standby node one initiated
> by postmested and other by init (unix process).
>
> The steps I am following are as follows,
>  - search for trigger file.
> - Complete the recovery- rename recovery.conf file.
> any step is missing I am not sure.

The backtrace of that orphan process would be helpful for the analysis.

Regards,

--
Fujii Masao
NIPPON TELEGRAPH AND TELEPHONE CORPORATION
NTT Open Source Software Center



--
Thanks & Regards,

Aaliya Zarrin
(+91)-9160665888