postgresql on windows

Re: postgresql on windows

Bill Grigg wrote:
[color=blue]
> 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[/color]

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).
[color=blue]
> 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.[/color]

Install as services. That way you won't have to remember to start
ipc-daemon and postmaster every time you want to use them.
[color=blue]
> 2. Are the commands shown in the README meant to be executed from the
> cygwin bash shell window? I assume so.[/color]

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.
[color=blue]
> 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[/color]

You'll see ipc-daemon.exe, and a few postmaster.exe' s.
[color=blue]
> 4. I do not really need to compile and build postgreSQL to get it
> running do I? I hope not.[/color]

Nope, you get a binary version with Cygwin.
[color=blue]
>
> Any tips or suggestions would be greatly appreciated.[/color]

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.
[color=blue]
>
> Bill[/color]