Обсуждение: Debugger
Hellow,<br />I continue to have problems using the debugger, can not achieve any breakpoint that is outside the postmaster.c?Can anyone give me any hint? Where do I mark a breakpoint so that I can follow the creation of an index to fileindex.c for example?<br />Thank,<br clear="all" /><br />-- <br />Pedro Belmino.<br />--------------------------------------------------------------------<br/># Ciência da Computação - UNIFOR<br /># <a href="mailto:pedrobelmino@gmail.com">pedrobelmino@gmail.com</a><br />--------------------------------------------------------------------
"Pedro Belmino" <pedrobelmino@gmail.com> writes: > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? Sounds to me like you attached the debugger to the wrong process. Start a session, find out the backend's PID, then attach to that. regards, tom lane
PostgreSQL consists of multiple processes, launched by postmaster, make sure you are debugging the right one. After connecting to a database with your favorite client (i.e. psql) you can use ps (if you have a unix-like system) or a task manager to determine a pid of postgres process and then attach to that process with a debugger. Pedro Belmino wrote: > Hellow, > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? > Thank, > > -- > Pedro Belmino. > -------------------------------------------------------------------- > # Ciência da Computação - UNIFOR > # pedrobelmino@gmail.com > -------------------------------------------------------------------- -- Alexey Klyukin http://www.commandprompt.com/ The PostgreSQL Company - Command Prompt, Inc.
"Pedro Belmino" <pedrobelmino@gmail.com> writes: > Hellow, > I continue to have problems using the debugger, can not achieve any > breakpoint that is outside the postmaster.c? Can anyone give me any hint? > Where do I mark a breakpoint so that I can follow the creation of an index > to file index.c for example? You have to start up your psql or other client run "SELECT pg_backend_pid();" and attach to that process in the debugger. It sounds like you've connected to the postmaster which doesn't actually do any of the work, it just forks other backends. -- Gregory Stark EnterpriseDB http://www.enterprisedb.com
I am using linux.
1. Inicializei the postgres the console by running. / Postgres.
2. Joined in psql through console and simulated. / Psql
3. Pg_backend_pid swirled SELECT () to get the id of the process;
4. In ide tried to use that process to attach the debugger but gives the following error message:
Unable to open file socket: target process not responding HotSpot VM or not loaded
Thank,
--
Pedro Belmino.
--------------------------------------------------------------------
# Ciência da Computação - UNIFOR
# pedrobelmino@gmail.com
--------------------------------------------------------------------
1. Inicializei the postgres the console by running. / Postgres.
2. Joined in psql through console and simulated. / Psql
3. Pg_backend_pid swirled SELECT () to get the id of the process;
4. In ide tried to use that process to attach the debugger but gives the following error message:
Unable to open file socket: target process not responding HotSpot VM or not loaded
Thank,
2007/10/19, Gregory Stark <stark@enterprisedb.com>:
"Pedro Belmino" <pedrobelmino@gmail.com> writes:
> Hellow,
> I continue to have problems using the debugger, can not achieve any
> breakpoint that is outside the postmaster.c? Can anyone give me any hint?
> Where do I mark a breakpoint so that I can follow the creation of an index
> to file index.c for example?
You have to start up your psql or other client run "SELECT pg_backend_pid();"
and attach to that process in the debugger. It sounds like you've connected to
the postmaster which doesn't actually do any of the work, it just forks other
backends.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
--
Pedro Belmino.
--------------------------------------------------------------------
# Ciência da Computação - UNIFOR
# pedrobelmino@gmail.com
--------------------------------------------------------------------
Excuse me,
My previous email, I had a problem formatting of my text. So it is not understandable.
Correcting:
Pinged the following steps in the console:
1. Pinged the command postgres to start.
2. Joined in psql.
3. Typed the following command to get the id of the process:
"SELECT pg_backend_pid();"
4. Tried to attach the id of the process to the debugger and gave the error:
"Unable to open socket file: target process not responding or HotSpot VM not loaded"
--
Pedro Belmino.
--------------------------------------------------------------------
# Ciência da Computação - UNIFOR
# pedrobelmino@gmail.com
--------------------------------------------------------------------
My previous email, I had a problem formatting of my text. So it is not understandable.
Correcting:
Pinged the following steps in the console:
1. Pinged the command postgres to start.
2. Joined in psql.
3. Typed the following command to get the id of the process:
"SELECT pg_backend_pid();"
4. Tried to attach the id of the process to the debugger and gave the error:
"Unable to open socket file: target process not responding or HotSpot VM not loaded"
2007/10/19, Pedro Belmino <pedrobelmino@gmail.com>:
I am using linux.
1. Inicializei the postgres the console by running. / Postgres.
2. Joined in psql through console and simulated. / Psql
3. Pg_backend_pid swirled SELECT () to get the id of the process;
4. In ide tried to use that process to attach the debugger but gives the following error message:
Unable to open file socket: target process not responding HotSpot VM or not loaded
Thank,2007/10/19, Gregory Stark <stark@enterprisedb.com>:
"Pedro Belmino" <pedrobelmino@gmail.com> writes:
> Hellow,
> I continue to have problems using the debugger, can not achieve any
> breakpoint that is outside the postmaster.c? Can anyone give me any hint?
> Where do I mark a breakpoint so that I can follow the creation of an index
> to file index.c for example?
You have to start up your psql or other client run "SELECT pg_backend_pid();"
and attach to that process in the debugger. It sounds like you've connected to
the postmaster which doesn't actually do any of the work, it just forks other
backends.
--
Gregory Stark
EnterpriseDB http://www.enterprisedb.com
--
Pedro Belmino.
--------------------------------------------------------------------
# Ciência da Computação - UNIFOR
# pedrobelmino@gmail.com
--------------------------------------------------------------------
--
Pedro Belmino.
--------------------------------------------------------------------
# Ciência da Computação - UNIFOR
# pedrobelmino@gmail.com
--------------------------------------------------------------------
Pedro Belmino wrote: > 4. Tried to attach the id of the process to the debugger and gave the error: > "Unable to open socket file: target process not responding or HotSpot VM not > loaded" You're trying to use a Java debugger to attach to a non-Java program (Postgres). That's not going to work. Use a tool like gdb or ddd instead. -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com