Thread: Installing debugger?
The current instructions at www.pgadmin.org on how to install the PL/pgSQL debugger read: "In order to use the debugger, a plugin is required on your server. This is included by default with EnterpriseDB, and is available for download on pgFoundry. It is installed as a contrib module with the Windows distribution of PostgreSQL 8.3 and above." However, the only download available from pgFoundry dates back to PostgreSQL 8.2, implying that it may not be compatible with 8.4. Further, there are no PGXS installation instructions for users who did not install from source. So ... does the debugger even still work? And if it does, how do I install it on an RHEL system with 8.4.2 RPM installed? --Josh
On Wed, Mar 10, 2010 at 6:03 PM, Josh Berkus <josh@agliodbs.com> wrote: > The current instructions at www.pgadmin.org on how to install the > PL/pgSQL debugger read: > > "In order to use the debugger, a plugin is required on your server. This > is included by default with EnterpriseDB, and is available for download > on pgFoundry. It is installed as a contrib module with the Windows > distribution of PostgreSQL 8.3 and above." > > However, the only download available from pgFoundry dates back to > PostgreSQL 8.2, implying that it may not be compatible with 8.4. > Further, there are no PGXS installation instructions for users who did > not install from source. > > So ... does the debugger even still work? Yes, you just need to use a CVS checkout instead of the older tarball, or get the binary bundled with any of the EDB installers. The only changes have been for compatibility with newer versions of Postgres. > And if it does, how do I > install it on an RHEL system with 8.4.2 RPM installed? You need a source tree, as noone ever got around to creating a PGXS build. -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
Dave > Yes, you just need to use a CVS checkout instead of the older tarball, > or get the binary bundled with any of the EDB installers. The only > changes have been for compatibility with newer versions of Postgres. This was extremely hard to make work, and very kludgy. Might be worth just saying in the docs that the debugger currently isn't supported except on EDB and One-Click installs. Having gone to some trouble to get it installed, however, I find that the "debugging" option on the pgadmin menu is still greyed out and inaccessible. What is pgAdmin looking for? --Josh Berkus
Hi Josh,
pgAdminIII checks for:
1. The plugin library (plugin_pldebugger.so/plugin_pldebugger.dll) is loaded using 'shared_preload_libraries". You may need to to modify the <DATADIR>/postgresql.conf. (Database Server Restart required).
2. The required functions for pldebugger in postgres database. You can install them using the sql file provided under the debugger module. (pldbgapi.sql)
You may need to restart the pgAdminIII in order to see the Debugger option.
Hope this helps.
--
Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company
On Fri, Mar 12, 2010 at 5:12 AM, Josh Berkus <josh@agliodbs.com> wrote:
DaveThis was extremely hard to make work, and very kludgy. Might be worth
> Yes, you just need to use a CVS checkout instead of the older tarball,
> or get the binary bundled with any of the EDB installers. The only
> changes have been for compatibility with newer versions of Postgres.
just saying in the docs that the debugger currently isn't supported
except on EDB and One-Click installs.
Having gone to some trouble to get it installed, however, I find that
the "debugging" option on the pgadmin menu is still greyed out and
inaccessible. What is pgAdmin looking for?
--Josh Berkus
--
Sent via pgadmin-support mailing list (pgadmin-support@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
On Fri, Mar 12, 2010 at 9:25 AM, Ashesh Vashi <ashesh.vashi@enterprisedb.com> wrote:
Hi Josh,pgAdminIII checks for:1. The plugin library (plugin_pldebugger.so/plugin_pldebugger.dll) is loaded using
Correction: It looks for plugin_debugger.so/plugin_debugger.dll.
'shared_preload_libraries". You may need to to modify the <DATADIR>/postgresql.conf. (Database Server Restart required).2. The required functions for pldebugger in postgres database. You can install them using the sql file provided under the debugger module. (pldbgapi.sql)You may need to restart the pgAdminIII in order to see the Debugger option.Hope this helps.--Ashesh VashiEnterpriseDB INDIA: Enterprise Postgres Company
--
Ashesh Vashi
EnterpriseDB INDIA: Enterprise Postgres Company
On Thu, Mar 11, 2010 at 11:42 PM, Josh Berkus <josh@agliodbs.com> wrote: > Dave > >> Yes, you just need to use a CVS checkout instead of the older tarball, >> or get the binary bundled with any of the EDB installers. The only >> changes have been for compatibility with newer versions of Postgres. > > This was extremely hard to make work, and very kludgy. Might be worth > just saying in the docs that the debugger currently isn't supported > except on EDB and One-Click installs. Feel free to provide a patch for the Makefile if you have that itch. I'm not going to say it isn't supported, as it is and works fine, it's just awkward to build. > Having gone to some trouble to get it installed, however, I find that > the "debugging" option on the pgadmin menu is still greyed out and > inaccessible. What is pgAdmin looking for? Superuser privs or ownership of the function. And have you added the preload library and installed the functions in the database, per the README? -- Dave Page EnterpriseDB UK: http://www.enterprisedb.com PG East Conference: http://www.enterprisedb.com/community/nav-pg-east-2010.do
Dave, > Feel free to provide a patch for the Makefile if you have that itch. > I'm not going to say it isn't supported, as it is and works fine, it's > just awkward to build. I figured the build issues around edb-debugger belong on that project's list. I'll just say that it won't build without hackery at this point. --Josh