Re: Where is the link to cygwin?

Have been using the W32 port and need to access the cygiwn version again
for a friend with w9X instead of wXP.
Need a version that will run the the Fat32 environment.

thanks muchly

Richard Sydney-Smith

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.772 / Virus Database: 519 - Release Date: 1/10/2004

On Monday 18 October 2004 13:49, Richard Sydney-Smith wrote:
> Have been using the W32 port and need to access the cygiwn version again
> for a friend with w9X instead of wXP.
> Need a version that will run the the Fat32 environment.
>

http://www.postgresql.org/docs/faqs/text/FAQ_CYGWIN

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

Reading this through comes an interesting point. With the windows 32
beta coming out an increasing number of people will be trialing
PostgreSQL. Those whoose machines are not up to spec for the W32 project
will want to run CYGWIN version on their ME /98/ NT4 boxes. Yet the
installation for this project is "harder" to run.

Question is it possible to include short cuts to initdb / start server /
stop server in the CYGWIN install package?
Thanks
R

-----Original Message-----
From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
Sent: Tuesday, 19 October 2004 9:17 AM
To: Richard Sydney-Smith
Cc: pgsql-cygwin(at)postgresql(dot)org
Subject: Re: [CYGWIN] Where is the link to cygwin?

On Monday 18 October 2004 13:49, Richard Sydney-Smith wrote:
> Have been using the W32 port and need to access the cygiwn version
> again for a friend with w9X instead of wXP. Need a version that will
> run the the Fat32 environment.
>

http://www.postgresql.org/docs/faqs/text/FAQ_CYGWIN

--
Robert Treat
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL

---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.772 / Virus Database: 519 - Release Date: 1/10/2004

---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.772 / Virus Database: 519 - Release Date: 1/10/2004

Richard Sydney-Smith schrieb:
> Reading this through comes an interesting point. With the windows 32
> beta coming out an increasing number of people will be trialing
> PostgreSQL. Those whoose machines are not up to spec for the W32 project
> will want to run CYGWIN version on their ME /98/ NT4 boxes. Yet the
> installation for this project is "harder" to run.
>
> Question is it possible to include short cuts to initdb / start server /
> stop server in the CYGWIN install package?

Yes,
A new initd script will come with 8.0,
which just calls pg_ctl and
adds service install/uninstall args.

> -----Original Message-----
> From: Robert Treat [mailto:xzilla(at)users(dot)sourceforge(dot)net]
> Sent: Tuesday, 19 October 2004 9:17 AM
> To: Richard Sydney-Smith
> Cc: pgsql-cygwin(at)postgresql(dot)org
> Subject: Re: [CYGWIN] Where is the link to cygwin?
>
>
> On Monday 18 October 2004 13:49, Richard Sydney-Smith wrote:
>
>>Have been using the W32 port and need to access the cygiwn version
>>again for a friend with w9X instead of wXP. Need a version that will
>>run the the Fat32 environment.
>>
>
>
> http://www.postgresql.org/docs/faqs/text/FAQ_CYGWIN
>

--
Reini Urban
http://xarch.tu-graz.ac.at/home/rurban/

Reini Urban wrote:
> Richard Sydney-Smith schrieb:
>
> Yes,
> 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 ? 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 ?

Regards,

ML

Marek Lewczuk schrieb:
> 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

rurban(at)reini /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin
$ ./pg_ctl.exe register

rurban(at)reini /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/

Your patch has been added to the PostgreSQL unapplied patches list at:

http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------

Reini Urban wrote:
> Marek Lewczuk schrieb:
> > 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
>
> rurban(at)reini /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin
> $ ./pg_ctl.exe register
>
> rurban(at)reini /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 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

We just added code to add the *.exe suffix for MinGW and I am hoping
this will fix your register problem on Cygwin too. Would you test a
recent snapshot and let me know if it works?

---------------------------------------------------------------------------

Reini Urban wrote:
> Marek Lewczuk schrieb:
> > 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
>
> rurban(at)reini /usr/src/postgresql/postgresql-8.0.0cvs/.inst/usr/sbin
> $ ./pg_ctl.exe register
>
> rurban(at)reini /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 6: Have you searched our list archives?
>
> http://archives.postgresql.org

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 359-1001
+ If your life is a hard drive, | 13 Roberts Road
+ Christ can be your backup. | Newtown Square, Pennsylvania 19073

Bruce Momjian wrote:
> We just added code to add the *.exe suffix for MinGW and I am hoping
> this will fix your register problem on Cygwin too. Would you test a
> recent snapshot and let me know if it works?

Latest CVS compilation fails, so I was not able to check pg_ctl.

make[4]: Leaving directory `/usr/src/pgsql/src/backend/parser'
gcc -O2 -Wall -Wmissing-prototypes -Wpointer-arith -Wendif-labels
-fno-strict-al
iasing pg_dump.o common.o pg_dump_sort.o pg_backup_archiver.o
pg_backup_db.o pg_
backup_custom.o pg_backup_files.o pg_backup_null.o pg_backup_tar.o
dumputils.o
../../../src/backend/parser/keywords.o -L../../../src/interfaces/libpq
-lpq -L..
/../../src/port -L/usr/local/lib -lpgport -lz -lreadline -lcrypt -o
pg_dump.exe

../../../src/port/libpgport.a(pgstrcasecmp.o)(.text+0x1b0):pgstrcasecmp.c:
multi
ple definition of `_pg_tolower'
../../../src/interfaces/libpq/libpq.a(dyofs00145.o)(.text+0x0): first
defined he
re
Info: resolving _optarg by linking to __imp__optarg (auto-import)
Info: resolving _optind by linking to __imp__optind (auto-import)
collect2: ld returned 1 exit status
make[3]: *** [pg_dump] Error 1
make[3]: Leaving directory `/usr/src/pgsql/src/bin/pg_dump'
make[2]: *** [all] Error 2
make[2]: Leaving directory `/usr/src/pgsql/src/bin'
make[1]: *** [all] Error 2
make[1]: Leaving directory `/usr/src/pgsql/src'
make: *** [all] Error 2

Best regards
ML