Thread: Postgres server on Windows 98
Does the Postgresql server work on Windows? Not just the client? _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Richard, On Thu, May 10, 2001 at 08:43:56PM -0000, Richard Church wrote: > Does the Postgresql server work on Windows? Not just the client? Many months ago, I tried PostgreSQL on Windows 98 so I could respond to a post on pgsql-ports. It seemed to work. So, my answer is a guarded "yes." However, Cygwin runs *much* worse on 9X and Me than it does on NT 4.0 and 2000 implying (IMO) the same for PostgreSQL. Unfortunately, I never ran the regression tests. Since, I no longer have access to a 9X or Me machine, I cannot do so now. Would you or someone else being willing to try out the regression tests and report back to the list? I recommend trying make installcheck (i.e., sequential schedule) first and then if that works, try make check (i.e., parallel schedule). Thanks, Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
I am a Windows NT/2000 man myself, but I am quite interested in getting it to work on Windows 98. I will find some time soon to set up my Windows 98 system and give it a try. >From: Jason Tishler <Jason.Tishler@dothill.com> >To: Richard Church <rfchurch@hotmail.com> >CC: pgsql-cygwin@postgresql.org >Subject: Re: [CYGWIN] Postgres server on Windows 98 >Date: Fri, 11 May 2001 14:13:03 -0400 > >Richard, > >On Thu, May 10, 2001 at 08:43:56PM -0000, Richard Church wrote: > > Does the Postgresql server work on Windows? Not just the client? > >Many months ago, I tried PostgreSQL on Windows 98 so I could respond to >a post on pgsql-ports. It seemed to work. So, my answer is a guarded >"yes." However, Cygwin runs *much* worse on 9X and Me than it does on >NT 4.0 and 2000 implying (IMO) the same for PostgreSQL. > >Unfortunately, I never ran the regression tests. Since, I no longer have >access to a 9X or Me machine, I cannot do so now. Would you or someone >else being willing to try out the regression tests and report back to the >list? I recommend trying make installcheck (i.e., sequential schedule) >first and then if that works, try make check (i.e., parallel schedule). > >Thanks, >Jason > >-- >Jason Tishler >Director, Software Engineering Phone: +1 (732) 264-8770 x235 >Dot Hill Systems Corp. Fax: +1 (732) 264-8798 >82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com >Hazlet, NJ 07730 USA WWW: http://www.dothill.com _________________________________________________________________________ Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com.
Richard, On Sat, May 12, 2001 at 12:55:45AM -0000, Richard Church wrote: > I will find some time soon to set up my Windows 98 system and give it a try. I look forward to your seeing your results. Thanks, Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
> Hello, > I've tried a few times to get regression tests to work on 98SE under > cygwin and never managed to get all the way through. I do tend to do > better under the serial tests than the parrallel tests (and the cygwin > 1.3.1 seems better than 1.1.7). Some time or another (it varies when) it > just seems to stop (e.g. the postgres backend terminates but psql is left, > this just seems to happen some times any way and isn't specific to the > tests). > - Stuart > > > -----Original Message----- > From: Jason Tishler [SMTP:Jason.Tishler@dothill.com] > Sent: Friday, May 11, 2001 7:13 PM > To: Richard Church > Cc: pgsql-cygwin@postgresql.org > Subject: Re: [CYGWIN] Postgres server on Windows 98 > > Richard, > > On Thu, May 10, 2001 at 08:43:56PM -0000, Richard Church wrote: > > Does the Postgresql server work on Windows? Not just the client? > > Many months ago, I tried PostgreSQL on Windows 98 so I could respond to > a post on pgsql-ports. It seemed to work. So, my answer is a guarded > "yes." However, Cygwin runs *much* worse on 9X and Me than it does on > NT 4.0 and 2000 implying (IMO) the same for PostgreSQL. > > Unfortunately, I never ran the regression tests. Since, I no longer have > access to a 9X or Me machine, I cannot do so now. Would you or someone > else being willing to try out the regression tests and report back to the > list? I recommend trying make installcheck (i.e., sequential schedule) > first and then if that works, try make check (i.e., parallel schedule). > > Thanks, > Jason > > -- > Jason Tishler > Director, Software Engineering Phone: +1 (732) 264-8770 x235 > Dot Hill Systems Corp. Fax: +1 (732) 264-8798 > 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com > Hazlet, NJ 07730 USA WWW: http://www.dothill.com > > ---------------------------(end of broadcast)--------------------------- > TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
Stuart, On Tue, May 15, 2001 at 09:56:58AM +0100, Henshall, Stuart - WCP wrote: > I've tried a few times to get regression tests to work on 98SE under > cygwin and never managed to get all the way through. I do tend to do better > under the serial tests than the parrallel tests (and the cygwin 1.3.1 seems > better than 1.1.7). Some time or another (it varies when) it just seems to > stop (e.g. the postgres backend terminates but psql is left, this just seems > to happen some times any way and isn't specific to the tests). Thank you very much for the above -- it is much appreciated. What version of PostgreSQL are you using? IIRC, the psql hang problem (especially with the parallel schedule) sounds like a problem that was fixed in 7.1. Do you get these hangs even with the serial schedule? Thanks, Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Hello,
I'm using 7.1 (I need plpgsql so am not using 7.1.1), and the
problem appears on the serial schedule (the parrallel schedule also hangs,
I've not had it complete the first 13 tests). I could try the serial test
again tonight and keep a server debug (-d2 I was thinking) output.
I hadn't really commented on it as I've had it go through an NT4
server ok (bar one random difference), and assumed it was win9x up to its
usual high jinx.
- Stuart
> -----Original Message-----
> From: Jason Tishler [SMTP:Jason.Tishler@dothill.com]
> Sent: Tuesday, May 15, 2001 12:52 PM
> To: Henshall, Stuart - WCP
> Cc: Pgsql-Cygwin
> Subject: Re: [CYGWIN] Postgres server on Windows 98
>
> Stuart,
>
> On Tue, May 15, 2001 at 09:56:58AM +0100, Henshall, Stuart - WCP wrote:
> > I've tried a few times to get regression tests to work on 98SE under
> > cygwin and never managed to get all the way through. I do tend to do
> better
> > under the serial tests than the parrallel tests (and the cygwin 1.3.1
> seems
> > better than 1.1.7). Some time or another (it varies when) it just seems
> to
> > stop (e.g. the postgres backend terminates but psql is left, this just
> seems
> > to happen some times any way and isn't specific to the tests).
>
> Thank you very much for the above -- it is much appreciated.
>
> What version of PostgreSQL are you using? IIRC, the psql hang problem
> (especially with the parallel schedule) sounds like a problem that was
> fixed in 7.1. Do you get these hangs even with the serial schedule?
>
> Thanks,
> Jason
>
> --
> Jason Tishler
> Director, Software Engineering Phone: +1 (732) 264-8770 x235
> Dot Hill Systems Corp. Fax: +1 (732) 264-8798
> 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
> Hazlet, NJ 07730 USA WWW: http://www.dothill.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 3: if posting/reading through Usenet, please send an appropriate
> subscribe-nomail command to majordomo@postgresql.org so that your
> message can get through to the mailing list cleanly
Stuart, On Tue, May 15, 2001 at 01:08:48PM +0100, Henshall, Stuart - WCP wrote: > I'm using 7.1 (I need plpgsql so am not using 7.1.1), Just curious, why can't you use 7.1.1 plpgsql? > and the > problem appears on the serial schedule (the parrallel schedule also hangs, > I've not had it complete the first 13 tests). I could try the serial test > again tonight and keep a server debug (-d2 I was thinking) output. Any more data that you can supply regarding why the (serial) regression tests fail on Windows 98 would be greatly appreciated. > I hadn't really commented on it as I've had it go through an NT4 > server ok (bar one random difference), and assumed it was win9x up to its > usual high jinx. A fair assessment. :,) Jason -- Jason Tishler Director, Software Engineering Phone: +1 (732) 264-8770 x235 Dot Hill Systems Corp. Fax: +1 (732) 264-8798 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com Hazlet, NJ 07730 USA WWW: http://www.dothill.com
Hello,
I ran the regression tests and it stopped working at the interval
test.
Here's the end of the postmaster (-i -d2 -o '-e') output (the full things
273KB):
DEBUG: query: SELECT '' AS to_timestamp_14, to_timestamp('995-1116',
'YYY-MMDD');
DEBUG: ProcessQuery
DEBUG: CommitTransactionCommand
DEBUG: StartTransactionCommand
DEBUG: query: SET DateStyle TO DEFAULT;
DEBUG: ProcessUtility: SET DateStyle TO DEFAULT;
DEBUG: CommitTransactionCommand
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 3787519 exited with status 0
DEBUG: proc_exit(0)
DEBUG: shmem_exit(0)
DEBUG: exit(0)
postmaster: reaping dead processes...
postmaster: CleanupProc: pid 3539923 exited with status 0
And heres the process list at the end (I had the postmaster in one cygwin
box and make installcheck in the other):
PID PPID PGID WINPID TTY UID STIME COMMAND
3886739 1 3886739 4291080557 -1 500 16:32:25 /usr/bin/BASH
47214991 3886739 47214991 4247810729 -1 500 16:33:19
/USR/LOCAL/BIN/IPC-DAEMON
47136187 3886739 47136187 4247826525 -1 500 16:33:54
/USR/LOCAL/PGSQL/BIN/POSTGRES
47094415 1 47094415 4247872881 -1 500 16:34:13 /usr/bin/BASH
47113859 47094415 47113859 4247850621 -1 500 16:35:27 /usr/bin/MAKE
47114319 47113859 47113859 4247909729 -1 500 16:35:28 /usr/bin/SH
47115115 47114319 47113859 4247904221 -1 500 16:35:28 /usr/bin/MAKE
47063671 47115115 47113859 4247883773 -1 500 16:35:28 /usr/bin/SH
47084119 47063671 47113859 4247945049 -1 500 16:35:29 /usr/bin/MAKE
47048611 47094415 47048611 4247913817 -1 500 16:35:37 /usr/bin/TAIL
47022775 47084119 47113859 4247921957 -1 500 16:35:38 /usr/bin/SH
47087371 47022775 47113859 4247917641 -1 500 16:35:38 /usr/bin/SH
46996679 47087371 47113859 4247970617 -1 500 16:36:58 /usr/bin/SH
I 47014927 47087371 47113859 4247965605 -1 500 16:36:59 /usr/bin/TEE
47001747 46996679 47113859 4247967161 -1 500 16:41:52
/USR/LOCAL/PGSQL/BIN/PSQL
3787739 3886739 3787739 4247876969 -1 500 16:45:49 /usr/bin/PS
For completeness here's the install check output:
<<mkic_4.out>>
I'll rerun and see if the same happens (I'm using pg7.1 of the pg site, is
there any reason to use cygwin's version?)
> -----Original Message-----
> From: Jason Tishler [SMTP:Jason.Tishler@dothill.com]
> Sent: Tuesday, May 15, 2001 3:40 PM
> To: Henshall, Stuart - WCP
> Cc: Pgsql-Cygwin
> Subject: Re: [CYGWIN] Postgres server on Windows 98
>
> Stuart,
>
> On Tue, May 15, 2001 at 01:08:48PM +0100, Henshall, Stuart - WCP wrote:
> > I'm using 7.1 (I need plpgsql so am not using 7.1.1),
>
> Just curious, why can't you use 7.1.1 plpgsql?
>
> > and the
> > problem appears on the serial schedule (the parrallel schedule also
> hangs,
> > I've not had it complete the first 13 tests). I could try the serial
> test
> > again tonight and keep a server debug (-d2 I was thinking) output.
>
> Any more data that you can supply regarding why the (serial) regression
> tests fail on Windows 98 would be greatly appreciated.
>
> > I hadn't really commented on it as I've had it go through an NT4
> > server ok (bar one random difference), and assumed it was win9x up to
> its
> > usual high jinx.
>
> A fair assessment. :,)
>
> Jason
>
> --
> Jason Tishler
> Director, Software Engineering Phone: +1 (732) 264-8770 x235
> Dot Hill Systems Corp. Fax: +1 (732) 264-8798
> 82 Bethany Road, Suite 7 Email: Jason.Tishler@dothill.com
> Hazlet, NJ 07730 USA WWW: http://www.dothill.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
> http://www.postgresql.org/search.mpl