Postgresql usage clip.

Bruce Momjian <pgman@candle.pha.pa.us> writes:

We support WIn95/98 clients, not servers.

I thought we did have a cygwin-based server port? If not, there's
a heckuva lot of useless "PORTNAME=win" conditional compilation in
the backend.

Mind you, I don't think any sane dbadmin would use Windoze as a
platform for a mission-critical application, regardless of database
engine choice. So the cygwin port is pretty much a toy IMHO.
If MySQL wants to have the toy-application market segment, they're
welcome to it.

We support servers on NT, but not on Win95/98. Cygwin supports both,
but the Win95/98 has missing features that we need. People have asked
about it, and they have said they were going to try Win95/98 and report
back on the problems they had, but no one has. I assume they got lots
of "unimplemented" messages from Cygwin and gave up.

IMO, having a 'toy' server during development on a win9x platform would be really nice. Coming from a MySQL/PHP background, it sure is nice to take the laptop out on a nice day and be able to develop 'real' applications that are then moved to a real server platform.

I just tried the latest NT port binaries, hoping that I could at least start up the server process. Even an extremely limited server on this platform would be welcome. Sometimes you don't get to choose your development OS :(

I have Cygwin installed, but when I try to start postgres.exe I get the following error message:

FATAL 1: SetPgUserName: no entry in host passwd file

I also find no postmaster in the install. So am I just wasting time?

Thanks,
John

--
/* SteeleSoft Consulting John Steele - Systems Analyst/Programmer
* We also walk dogs... jsteele@writeme.com
* http://www.gamecomputer.com/ssc/
*/

We support servers on NT, but not on Win95/98. Cygwin supports both,
but the Win95/98 has missing features that we need. People

have asked

about it, and they have said they were going to try Win95/98

and report

back on the problems they had, but no one has. I assume

they got lots

of "unimplemented" messages from Cygwin and gave up.

I just tried the latest NT port binaries, hoping that I
could at least start up the server process. Even an
extremely limited server on this platform would be welcome.
Sometimes you don't get to choose your development OS :(

I have Cygwin installed, but when I try to start
postgres.exe I get the following error message:

FATAL 1: SetPgUserName: no entry in host passwd file

I also find no postmaster in the install. So am I just
wasting time?

Thanks,
John

I tried and succeeded in getting Postgres to run on an NT server.
There are some directions on here that are helpful.
There is a util that collects all the user names and groups and puts them in
a /etc/groups and /etc/users files.

Someone directed me to this site
http://www.freebsd.org/~kevlo/postgres/portNT.html

Respectfully - Joseph Showalter

Here are some ideas about the Win9x port:

Cygwin runs on Win9x quite well, I think only some security features are
missing. We have made some investigation with pgsql on win95 (with Cygwin
B20.1) and found that the problem is (should be ;-) somewhere in server side
libpq (pg_flush) and here I was stopped due "unsufficient resources" (=
time) ;-). I have tested the SysV IPC functionality and it worked well, so
this should not be the problem.
I will try it with the newest cygwin library and do more debugging.

There are also some new interesting features in the newest cygwin that could
be implemented in the WinNT port (like AF_UNIX sockets)

Dan

PS: some money would help ;-)

On Tue, 30 May 2000, John Steele wrote:

IMO, having a 'toy' server during development on a win9x platform
would be really nice. Coming from a MySQL/PHP background, it sure is
nice to take the laptop out on a nice day and be able to develop 'real'
applications that are then moved to a real server platform.

That's why I have FreeBSD on my laptop. If I'm going to be gone for any
length of time or it's just nice outside I have a mobile development
platform all set to go. PostgreSQL, apache, php, qmail, xemacs and
everything else I need for development, wireless lan to keep access to
the net if I'm close enough. Even have wine installed in case I feel like
playing solitare!

Vince.
--
==========================================================================
Vince Vielhaber -- KA8CSH email: vev@michvhf.com http://www.pop4.net
128K ISDN from $22.00/mo - 56K Dialup from $16.00/mo at Pop4 Networking
Online Campground Directory http://www.camping-usa.com
Online Giftshop Superstore http://www.cloudninegifts.com
==========================================================================

John Steele wrote:

IMO, having a 'toy' server during development on a win9x platform would be really nice. Coming from a MySQL/PHP background, it sure is nice to take the laptop out on a nice day and be able to develop 'real' applications that are then moved to a real server platform.

What kind of LAPTOP do you mean? Wouldn't a slightly bigger
disk let you install NT or Win2K as alternate boot to have at
least something worth installing development tools at all?

I just tried the latest NT port binaries, hoping that I could at least start up the server process. Even an extremely limited server on this platform would be welcome. Sometimes you don't get to choose your development OS :(

If a piece doesn't fit, don't force it, use a bigger hammer.

Postgres needs some functionality from the OS. Seems Win9x
doesn't provide all that, but mucking around with
requirements of Postgres is the wrong way here. Especially
since Win9x was already dead when born, only that Microsoft
keeps it in some zombie state until they have something
better. Seems Win2K is - so I think it's wasted efford to
hack Win9x support into Postgres.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #

We support servers on NT, but not on Win95/98. Cygwin supports both,

What's the performance like?

NT doesn't do forks well and Postgres uses forks right?

Cheerio,

Link.