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

Thanks for your response Albe! I had the single quote in   shared_preload_libraries =
'$libdir/plugins/plugin_debugger.dll'but forgot to put it when posting this question.
 


When running in the foreground, I have the same problem when running postgres.exe with super user postgres. I don't
thinkit is a permission problem. The service Postgresql-x64-9.3 is shown stopped.
 


Server [localhost]:
Database [postgres]:
Port [5432]:
Username [postgres]:
psql: could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "localhost" (::1) and accepting
        TCP/IP connections on port 5432?
could not connect to server: Connection refused (0x0000274D/10061)
        Is the server running on host "localhost" (127.0.0.1) and accepting
        TCP/IP connections on port 5432?


When I commented out the above  # shared_preload_libraries = '$libdir/plugins/plugin_debugger.dll' in the postgres.conf
file,no problem!
 

Michelle


-----Original Message-----
From: Albe Laurenz [mailto:laurenz.albe@wien.gv.at] 
Sent: Wednesday, April 16, 2014 1:48 AM
To: Bui, Michelle P; pgsql-admin@postgresql.org
Subject: RE: shared_preload_libraries = $libdir/plugins/plugin_debugger.dll causes server not started

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-PLPgS
> QL-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
appropriateoptions) and see what errors you get?
 

Yours,
Laurenz Albe