Reini Urban wrote:Richard Sydney-Smith schrieb: A new initd script will come with 8.0, which just calls pg_ctl and adds service install/uninstall args.
Reini,
a few days ago you wrote that you are working on plperl patch for cygwin - how are doing with this ?
well, bruce said that it should work now. I got reproducable crashes with IPC. But I really think that are problems with our cygserver, not with postgresql. That's why I'm busy with testing our cygserver, and a few libtool bugs.
I also found a bug in "pg_ctl register" function - it adds a service, but the path to the pg_ctl file is /usr/local/pgsl/bin/pg_ctl.exe - which is not available in windows.... or "pg_ctl register" will not work on cygwin ?
Ah, thanks Marek!
$ psservice config PostgreSQL
PsService v1.01 - local and remote services viewer/controller Copyright (C) 2001 Mark Russinovich Sysinternals - www.sysinternals.com
SERVICE_NAME: PostgreSQL
(null)
TYPE : 10 WIN32_OWN_PROCESS
START_TYPE : 2 AUTO_START
ERROR_CONTROL : 1 NORMAL
BINARY_PATH_NAME : /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin/./pg_ctl.exe
runservice -N "PostgreSQL" -D "/usr/share/postgresql/data"
LOAD_ORDER_GROUP :
TAG : 0
DISPLAY_NAME : PostgreSQL
DEPENDENCIES : RPCSS
SERVICE_START_NAME: LocalSystem
We need another patch to pg_ctl to convert the exe path.
cd /usr/src/postgresql/postgresql-8.0.0cvs/src/bin/pg_ctl patch -p0 < cyg-ctlpaths.patch make cp ./pg_ctl.exe /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin
$ ./pg_ctl.exe unregister
[EMAIL PROTECTED] /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin $ ./pg_ctl.exe register
[EMAIL PROTECTED] /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin $ psservice config PostgreSQL
PsService v1.01 - local and remote services viewer/controller Copyright (C) 2001 Mark Russinovich Sysinternals - www.sysinternals.com
SERVICE_NAME: PostgreSQL
(null)
TYPE : 10 WIN32_OWN_PROCESS
START_TYPE : 2 AUTO_START
ERROR_CONTROL : 1 NORMAL
BINARY_PATH_NAME : f:\prog\gnu\cygwin\postgresql\postgresql-8.0.0cvs\.inst\usr\sbin\pg_ctl.
exe runservice -N "PostgreSQL" -D "/usr/share/postgresql/data"
LOAD_ORDER_GROUP :
TAG : 0
DISPLAY_NAME : PostgreSQL
DEPENDENCIES : RPCSS
SERVICE_START_NAME: LocalSystem
-- Reini Urban http://xarch.tu-graz.ac.at/home/rurban/
Index: pg_ctl.c
===================================================================
RCS file: /projects/cvsroot/pgsql/src/bin/pg_ctl/pg_ctl.c,v
retrieving revision 1.39
diff -u -b -c -r1.39 pg_ctl.c
*** pg_ctl.c 16 Oct 2004 03:10:14 -0000 1.39
--- pg_ctl.c 20 Oct 2004 01:02:56 -0000
***************
*** 22,27 ****
--- 22,28 ----
#include "getopt_long.h"
#if defined(__CYGWIN__)
+ #include <sys/cygwin.h>
#include <windows.h>
#endif
***************
*** 814,819 ****
--- 815,823 ----
{
static char cmdLine[MAXPGPATH];
int ret;
+ #ifdef __CYGWIN__
+ static char buf[MAXPGPATH];
+ #endif
if (registration)
ret = find_my_exec(argv0, cmdLine);
***************
*** 824,829 ****
--- 828,838 ----
write_stderr(_("%s: could not find exe"), progname);
exit(1);
}
+ #ifdef __CYGWIN__
+ /* need to convert to windows path */
+ cygwin_conv_to_full_win32_path (cmdLine, buf);
+ strcpy(cmdLine, buf);
+ #endif
if (registration)
{
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
