On 13/04/2009 13:15, Raymond O'Donnell wrote:
> On 13/04/2009 05:09, schatz wrote:
>> I have the same problem, debugger option is disabled & have the
>> plugin_debugger & profiler.dll in the lib directory. I don't know how to do
>> pg)dumpall/psql_reload from pgadmin3. Can u pls. help me out how to do this.
>> How do I make sure debugger funcions are loaded in my dbase?
>
> You don't use pgAdmin for these; use pg_dumpall and psql themselves
> instead. PgAdmin just lets you do per-database dumps and reloads.
....and I meant to add that to reload the debugger functions, you do
something like this:
psql -f pldbgapi.sql <your_database>
The file pldbgapi.sql should be in the share/contrib directory. If you
want to have the functions loaded be default into every new database you
create, install them into template1.
HTH,
Ray.
------------------------------------------------------------------
Raymond O'Donnell, Director of Music, Galway Cathedral, Ireland
rod@iol.ie
Galway Cathedral Recitals: http://www.galwaycathedral.org/recitals
------------------------------------------------------------------