[CLUE-Tech] [OT] Postgres on Windows

[Grant Johnson]

Sucks, no, as good as on Linux, no again.  My Celeron 300 (Linux) system 
with IDE drives is faster than my P4 933 (win2k) with SCSI drives even 
though both have 256M of memory, HOWEVER.....  Event the win2k machine 
is faster than our production DB server, which is very expensive.

Now for the part that does suck:  You need to use CYGWIN, and CYGIPC. 
 The IPC part does not come with CYGWIN, but Postgres does, which makes 
it a little confusing as to why it did not work.  I use Postgres on 
win2k at work for prototyping database stuff before the keepers of the 
oracle have seen fit to allow me the privledge of having an instance on 
the test/development server.
 
Starting it looks like this:
ipc-daemon &
./pgstart.sh
fg


shutting it down has to be done in a seperate window:
./pgstop.sh
ps   (look for ipc-daemon)
kill 2040 (or whatever IPC was)

Then you can close both CYCWIN windows.

I have attached some start-up/shutdown scripts from my at work machine.

Matt Gushee wrote:

>Hey, folks--
>
>I am going to be talking about a database conversion project with the
>director of a non-profit organization tomorrow. I'm going to assess
>their needs, make some recommendations, and possibly implement the
>project. I don't have a very clear picture yet of what's going to be
>involved; I know the target platform is Win2k--that's non-negotiable
>--but I get the impression they're not sure what they want for a 
>database yet. Depending on their requirements, resources, etc., I may
>want to recommend something other than Access--such as PostgreSQL. 
>
>However, I've heard that PostgreSQL on Windows "sucks." I'm not sure
>why, just that it sucks. So I'd like to ask if anyone here has recently
>used Postgres on Windows. If so, do you think it sucks? In what way?
>
>By the way, I'm aware that MySQL runs on Windows--I've set up a MySQL
>database on Win2k, and it seemed to work well. But I guess I'm biased
>because it lacks things like transactions. That's probably not very
>important for this project, but what is important is that it doesn't
>support UTF-8, which will likely be the encoding of choice.
>

-------------- next part --------------
#!/usr/bin/sh
pg_ctl -D /pgdata -w -mf stop
-------------- next part --------------
#!/usr/bin/sh
pg_ctl -D /pgdata -l logfile -o -i start
-------------- next part --------------
pg_ctl status -D /pgdata
-------------- next part --------------
#!/usr/bin/sh
pg_ctl -D /pgdata -w -ms stop
-------------- next part --------------
A non-text attachment was scrubbed...
Name: pgscr.tgz
Type: application/x-compressed
Size: 295 bytes
Desc: not available
Url : http://cluedenver.org/pipermail/clue-tech/attachments/20020412/c9dceddd/pgscr.bin