postgresql on windows

[Bill Grigg]

Gentlemen,

I am hoping to be able to use GForge on my windows PC. To that end I
have installed:
1. cygwin
2. reinstalled cygwin and selected cygipc, postgreSQL and a few other
things
3. PHP
4 Apache
5. downloaded and installed the GForge3 directory tree

I am listing the above just in case someone out there thinks I should
uninstall some stuff. In any event, this is a learning process for me,
and I am still learning. One thing I think I have learned, is that
with the correct installation options selected, I could have just done
the Internet cygwin install, and not have bothered with separately
installing Apache and PHP. Recently, someone very kindly pointed me to
http://www.tishler.net/jason/softwar...l-7.3.2.README
which I am currently trying to follow. My plan is to reinstall cygwin,
but making sure that I include all of the packages mentioned in the
README. Here are some things that are a little unclear right now:
1. Should I do the basic install, or the NT services? I will assume
NT services unless someone says otherwise.
2. Are the commands shown in the README meant to be executed from the
cygwin bash shell window? I assume so.
3. Assuming that I install the NT services version, what will I see
running under Windows Task Manager - Processes? I assume there will be
something that appears there
4. I do not really need to compile and build postgreSQL to get it
running do I? I hope not.

Any tips or suggestions would be greatly appreciated.

Bill

[Chris Church]

Bill Grigg wrote:

Gentlemen,

I am hoping to be able to use GForge on my windows PC. To that end I
have installed:
1. cygwin
2. reinstalled cygwin and selected cygipc, postgreSQL and a few other
things
3. PHP
4 Apache
5. downloaded and installed the GForge3 directory tree

I am listing the above just in case someone out there thinks I should
uninstall some stuff. In any event, this is a learning process for me,
and I am still learning. One thing I think I have learned, is that
with the correct installation options selected, I could have just done
the Internet cygwin install, and not have bothered with separately
installing Apache and PHP. Recently, someone very kindly pointed me to
http://www.tishler.net/jason/softwar...l-7.3.2.README
This is definitely *THE* readme for Postgres on Windows (Cygwin). I
would personally stick with the native Windows versions of Apache and
PHP and not the cygwin ones, but that's just me. If you were going to
run this setup for production use, I would suggest running on Linux or
looking into a commercial version of Postgres (such as the one from
dbExperts, which I haven't tried yet, but plan to soon).
which I am currently trying to follow. My plan is to reinstall cygwin,
but making sure that I include all of the packages mentioned in the
README. Here are some things that are a little unclear right now:
1. Should I do the basic install, or the NT services? I will assume
NT services unless someone says otherwise.
Install as services. That way you won't have to remember to start
ipc-daemon and postmaster every time you want to use them.
2. Are the commands shown in the README meant to be executed from the
cygwin bash shell window? I assume so.
Yes, run them from the Cygwin shell. Note that Cygwin inherits your
PATH environment variable from Windows, so certain commands (like NET,
to add a user) are actually calling Windows programs.
3. Assuming that I install the NT services version, what will I see
running under Windows Task Manager - Processes? I assume there will be
something that appears there
You'll see ipc-daemon.exe, and a few postmaster.exe's.
4. I do not really need to compile and build postgreSQL to get it
running do I? I hope not.
Nope, you get a binary version with Cygwin.

Any tips or suggestions would be greatly appreciated.
If you have problems, I would most likely suspect file/directory
permissions on your Postgres data directory (/usr/share/postgresql/data
or whatever) as the cause. Make sure these files are owned and
accessible by the 'postgres' user, or whatever user name your postmaster
service is running as.

Bill