Re: shared_preload_libraries = $libdir/plugins/plugin_debugger.dll causes server not started

From: Albe Laurenz <laurenz(dot)albe(at)wien(dot)gv(dot)at>
To: "Bui, Michelle P *EXTERN*" <michelle(dot)p(dot)bui(at)boeing(dot)com>, "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: shared_preload_libraries = $libdir/plugins/plugin_debugger.dll causes server not started
Date: 2014-04-16 08:47:36
Message-ID: A737B7A37273E048B164557ADEF4A58B17CF0D37@ntex2010i.host.magwien.gv.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Bui, Michelle P wrote:
> Hi – I am new to Postgresql. I installed Postgresql on my Windows 7 laptop, and things run fine until
> I tried to turn on the debugger using the methodology illustrated in this link:

Disclaimer: I don't know much about Windows.

> http://www.postgresonline.com/journal/archives/214-Using-PgAdmin-PLPgSQL-Debugger.html
>
> 1. shared_preload_libraries = $libdir/plugins/plugin_debugger.dll in the file postgresql.conf

This is missing the single quotes.

> 2. Install the file pldbgapi.sql in the database
>
> 3. Restart your PostgreSQL server process
>
>
>
> I tried re-starting the process (actually the service that runs the server), I got the message: “The
> operation could not be completed, access is denied”.

Could it be a permission problem?
Can you verify that the PostgreSQL server process has the right to read and execute the file?

Can you try to start the Server in the foreground (directly calling postgresql.exe
frpm the command line with the appropriate options) and see what errors you get?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Bui, Michelle P 2014-04-16 16:20:55 Re: shared_preload_libraries = $libdir/plugins/plugin_debugger.dll causes server not started
Previous Message Bui, Michelle P 2014-04-16 06:04:46 shared_preload_libraries = $libdir/plugins/plugin_debugger.dll causes server not started