pgsql: Fix assorted issues in pg_ctl's pgwin32_CommandLine(). - Mailing list pgsql-committers

From Tom Lane
Subject pgsql: Fix assorted issues in pg_ctl's pgwin32_CommandLine().
Date
Msg-id E1VmXaN-0006np-OF@gemulon.postgresql.org
Whole thread Raw
List pgsql-committers
Fix assorted issues in pg_ctl's pgwin32_CommandLine().

Ensure that the invocation command for postgres or pg_ctl runservice
double-quotes the executable's pathname; failure to do this leads to
trouble when the path contains spaces.

Also, ensure that the path ends in ".exe" in both cases and uses
backslashes rather than slashes as directory separators.  The latter issue
is reported to confuse some third-party tools such as Symantec Backup Exec.

Also, rewrite the function to avoid buffer overrun issues by using a
PQExpBuffer instead of a fixed-size static buffer.  Combinations of
very long executable pathnames and very long data directory pathnames
could have caused trouble before, for example.

Back-patch to all active branches, since this code has been like this
for a long while.

Naoya Anzai and Tom Lane, reviewed by Rajeev Rastogi

Branch
------
REL8_4_STABLE

Details
-------
http://git.postgresql.org/pg/commitdiff/6cb109a81289aec8c9078cc96fb721ff9e91d14d

Modified Files
--------------
src/bin/pg_ctl/pg_ctl.c |   76 +++++++++++++++++++++++++----------------------
1 file changed, 41 insertions(+), 35 deletions(-)


pgsql-committers by date:

Previous
From: Tom Lane
Date:
Subject: pgsql: Fix assorted issues in pg_ctl's pgwin32_CommandLine().
Next
From: Alvaro Herrera
Date:
Subject: pgsql: Don't TransactionIdDidAbort in HeapTupleGetUpdateXid