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