Re: Postgres 7.4.3-1, plperl and perl-5.8.2 -cygwin install - server crash -win2000

2004-08-26 Thread Kumar Pandey
I actually just use cygserver. I made sure from services that ipc-daemon2 wasn't running. Also I'm using the same user to run initdb, postmaster which has sysadmin privilege in my box. cygserver ins run as service under LOcal system account. I'll install the 7.4.5-1 when its available (I still

Re: Postgres 7.4.3-1, plperl and perl-5.8.2 -cygwin install - server crash -win2000

2004-08-26 Thread Reini Urban
Kumar Pandey schrieb: > DEBUG: PortalRun DEBUG: reaping dead processes DEBUG: child process (PID 2168) exited with exit code 128 LOG: server process (PID 2168) exited with exit code 128 LOG: terminating any other active server processes LOG: all server processes terminated; reinitializing DE

Re: Postgres 7.4.3-1, plperl and perl-5.8.2 -cygwin install - server crash -win2000

2004-08-26 Thread Gerrit P. Haase
Kumar wrote: > I did a fresh cygwin install of Postgres 7.4.3-1, > perl-5.8.2-1. Both are updated now, so use the latest. > plperl was installed fine and I could create a perl > function with no problem. > However using perl fuction in a SQL like so - > select empcomp(employee) from employee >

Re: Postgres 7.4.3-1, plperl and perl-5.8.2 -cygwin install - server crash -win2000

2004-08-26 Thread Kumar Pandey
--- "Gerrit P. Haase" <[EMAIL PROTECTED]> wrote: > If this fails you can try to find a mirror where it > is still available > (a mirror which was not updated at least the last > few weeks), then you > may try to find it at > ftp://mirrors.rcn.net/pub/sourceware/cygwin/release/perl > where I'm cur

Re: Postgres 7.4.3-1, plperl and perl-5.8.2 - server crashes

2004-08-24 Thread Kumar Pandey
Bummer, plperl was installed and I was able to create perl functions. However while executing the fucntion from SQL , database server crashes. Oh well I guess I'll have to wait for the new build of 7.4.5 in cygwin. Kumar --- Kumar Pandey <[EMAIL PROTECTED]> wrote: > Thanks Gerrit. > tar for some

Re: Postgres 7.4.3-1, plperl and perl-5.8.2 - working!

2004-08-24 Thread Kumar Pandey
Thanks Gerrit. tar for some reason didn't completely copy the files to c:\cygwin\bin. I extracted it in a temp directory and copied it over and creatlang plperl worked. Kumar --- "Gerrit P. Haase" <[EMAIL PROTECTED]> wrote: > Kumar schrieb: > > You must use Cygwin tools to extract, Unzipping

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Jason Tishler
Reini, On Tue, Aug 24, 2004 at 08:34:28PM +0200, Reini Urban wrote: > Jason Tishler schrieb: > >On Tue, Aug 24, 2004 at 04:11:55PM +0200, Reini Urban wrote: > >>Can you write a short paragraph about the supported charsets also > >>then, please? Previous versions only supported LATIN1, and I haven'

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Reini Urban
Jason Tishler schrieb: Reini, On Tue, Aug 24, 2004 at 04:11:55PM +0200, Reini Urban wrote: Jason Tishler schrieb: On Tue, Aug 24, 2004 at 10:56:18AM +0200, Gerrit P. Haase wrote: I don't know if postgres for Cygwin will be maintained in future, I'm still maintaining Cygwin PostgreSQL... Can you w

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Gerrit P. Haase
Kumar schrieb: > I unzipped perl-5.8.2-1.tar.bz2 from > http://gatekeeper.research.compaq.com/pub/cygwin/release/perl/ > under c:\cygwin however the problem persists. > Here's the cygcheck stack > $ cygcheck /usr/lib/postgresql/plperl.dll > C:/cygwin/lib/postgresql/plperl.dll > C:\cygwin\bin\

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Kumar Pandey
I unzipped perl-5.8.2-1.tar.bz2 from http://gatekeeper.research.compaq.com/pub/cygwin/release/perl/ under c:\cygwin however the problem persists. Here's the cygcheck stack $ cygcheck /usr/lib/postgresql/plperl.dll C:/cygwin/lib/postgresql/plperl.dll C:\cygwin\bin\postgres.exe C:\cygwin\bin

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Jason Tishler
On Tue, Aug 24, 2004 at 05:20:46PM +0200, Gerrit P. Haase wrote: > Since perl-5.8.2 for Cygwin was released in 2003 the chances are good > that every user of Cygwin has it in the local repository, it isn't > offered by Setup, but old packages are not deleted automatically, have > you looked in your

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Gerrit P. Haase
Kumar schrieb: > --- "Gerrit P. Haase" <[EMAIL PROTECTED]> wrote: >> >> As third option, I'll upload the perl-5.8.2 package >> again, though this >> may last some hours until it arrives at your mirror. >> >> Gerrit > Thanks Gerrit > I'm just gettign my feet wet with postgres and cygwin > so I

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Jason Tishler
Reini, On Tue, Aug 24, 2004 at 04:11:55PM +0200, Reini Urban wrote: > Jason Tishler schrieb: > >On Tue, Aug 24, 2004 at 10:56:18AM +0200, Gerrit P. Haase wrote: > >>I don't know if postgres for Cygwin will be maintained in future, > > > >I'm still maintaining Cygwin PostgreSQL... > > BTW: Thanks

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Kumar Pandey
--- "Gerrit P. Haase" <[EMAIL PROTECTED]> wrote: > > As third option, I'll upload the perl-5.8.2 package > again, though this > may last some hours until it arrives at your mirror. > > Gerrit Thanks Gerrit I'm just gettign my feet wet with postgres and cygwin so I'll wait for your third option

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Reini Urban
Jason Tishler schrieb: On Tue, Aug 24, 2004 at 10:56:18AM +0200, Gerrit P. Haase wrote: I don't know if postgres for Cygwin will be maintained in future, I'm still maintaining Cygwin PostgreSQL... BTW: Thanks for the additional cygserver SEMMNS paragraph. Can you write a short paragraph about the s

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Jason Tishler
On Tue, Aug 24, 2004 at 10:56:18AM +0200, Gerrit P. Haase wrote: > I don't know if postgres for Cygwin will be maintained in future, I'm still maintaining Cygwin PostgreSQL... > if so, maybe the postgres maintainer includes plperl (or updates the > postgres package if plperl is already included t

Re: Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-24 Thread Gerrit P. Haase
Kumar wrote: > Hi > I'm trying to install plperl in Postgres 7.4.3-1 that > comes with cygwin on XP Home edition. > as per cygcheck - plperl install is failing as it > can't find perl5.8.2 dll. > cygwin installer only allows me to install either > perl 5.6.1-2 or perl perl-5.8.5.3 > How do I

Postgres 7.4.3-1, plperl and perl-5.8.2

2004-08-23 Thread Kumar Pandey
Hi I'm trying to install plperl in Postgres 7.4.3-1 that comes with cygwin on XP Home edition. as per cygcheck - plperl install is failing as it can't find perl5.8.2 dll. cygwin installer only allows me to install either perl 5.6.1-2 or perl perl-5.8.5.3 How do I intall perl-5.8.2 so that plp