Обсуждение: 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-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

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

Michelle P Bui wrote:
>>> 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”.

> When running in the foreground, I have the same problem when running postgres.exe with super user
> postgres. I don't think it 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!

The message from psql is not important - it just shows that the server isn't running.

The important thing would be to know the messages that the *server* emits
when you try to start it in the foreground.  They should be either printed
to the console or written to the PostgreSQL log file.

Why are you certain that it is not a permission problem?  Maybe the
"super user postgres" has no permission.

I guess that you have double-checked that the DLL is for the correct
PostgreSQL version and architecture.

One thing that you could do is using Procmon to find out what actually
happens during server start and where the error occurs.

Yours,
Laurenz Albe

That would be my next step then.

Thanks much,
Michelle 

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

Michelle P Bui wrote:
>>> 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”.

> When running in the foreground, I have the same problem when running 
> postgres.exe with super user postgres. I don't think it is a permission problem. The service Postgresql-x64-9.3 is
shownstopped.
 
> 
> 
> 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!

The message from psql is not important - it just shows that the server isn't running.

The important thing would be to know the messages that the *server* emits when you try to start it in the foreground.
Theyshould be either printed to the console or written to the PostgreSQL log file.
 

Why are you certain that it is not a permission problem?  Maybe the "super user postgres" has no permission.

I guess that you have double-checked that the DLL is for the correct PostgreSQL version and architecture.

One thing that you could do is using Procmon to find out what actually happens during server start and where the error
occurs.

Yours,
Laurenz Albe