From: PG Bug reporting form <noreply@postgresql.org>
To: pgsql-bugs@lists.postgresql.org
Cc: rfrank@riministreet.com
Subject: BUG #18459: running pg_ctl.exe from inside a program running as a Windows service returns "error code 6"
Date: Thu, 09 May 2024 18:28:02 +0000
Message-ID: <18459-ae3443805592f4bc@postgresql.org> (raw)
The following bug has been logged on the website:
Bug reference: 18459
Logged by: Rick Frank
Email address: rfrank@riministreet.com
PostgreSQL version: 15.3
Operating system: Windows
Description:
We have a program written in Go that launches postgressql. Postgres starts
as a separate process, but under control of our program. This works fine
running the program interactively with our program in a folder under
“C:\Program Files”. But Postgres won’t start when we run our program as a
Windows service, even if the postgres programs and database are in a
different folder. If we have our program in any folder except “C:\Program
Files”, it works running as a service.
I tried with the service running under "Local System" and with a named
Administrator account; same error each time. I made sure that all users have
Full Control permissions to the folder where Postgres resides. Postgres
programs and data are in the same folder, in "C:\ProgramData" folder.
The program is using a Go package called embedded-postgres. That package
starts Postgres using pg_ctl.exe. Here is the error that pg_ctl.exe
returns:
"pg_ctl: could not start server: error code 6"
I can’t find any info saying what this message means. Any ideas what this
means?
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: noreply@postgresql.org, pgsql-bugs@lists.postgresql.org, rfrank@riministreet.com
Subject: Re: BUG #18459: running pg_ctl.exe from inside a program running as a Windows service returns "error code 6"
In-Reply-To: <18459-ae3443805592f4bc@postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox