Re: a few questions

Bill,

On Tue, Jul 29, 2003 at 11:28:11AM -0400, William Grigg wrote:
> 2. reinstalled cygwin and selected cygipc, postgreSQL and
^^^^^^

Note you must use cygipc 1.14-1 from Chuck's site:

http://www.neuro.gatech.edu/users/cwilson/cygutils/cygipc/index.html

cygipc 2.00 will *not* work with the current, official Cygwin PostgreSQL
package.

> Recently, someone very kindly pointed me to
> http://www.tishler.net/jason/software/postgresql/postgresql-7.3.2.README

You probably should use the latest version instead:

http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README

Although, the 7.3.3 README needs some updating for XP Home which I hope
to do for 7.3.4 shortly.

> 1. Should I do the basic install, or the NT services? I will assume NT
> services unless someone says otherwise.

If your platform supports NT services, then definitely use this
installation option.

> 2. Are the commands shown in the README meant to be executed from the
> cygwin bash shell window? I assume so.

Yes.

> 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

Under Cygwin you will see:

$ ps -fupostgres
UID PID PPID TTY STIME COMMAND
postgres 580 1 ? 09:27:35 /usr/bin/cygrunsrv
postgres 2304 580 ? 09:27:36 /usr/bin/postgres
postgres 1092 2304 ? 09:27:39 /usr/bin/postgres
postgres 312 1092 ? 09:27:39 /usr/bin/postgres

Under Windows you will see:

$ pslist
[snip]
Name Pid Pri Thd Hnd Mem User Time Kernel Time Elapsed Time
[snip]
cygrunsrv 580 8 4 59 1572 0:00:00.020 0:00:00.010 0:01:33.043
postgres 1244 8 4 240 4188 0:00:00.060 0:00:00.100 0:01:32.893
postgres 1092 8 5 140 3464 0:00:00.020 0:00:00.080 0:01:29.188
postgres 312 8 3 131 3600 0:00:00.020 0:00:00.070 0:01:29.118

> 4. I do not really need to compile and build postgreSQL to get it running do I? I hope not.

Normally, you don't. However, since you are using the combination of
Apache, PHP, and PostgreSQL, you *may* need to build one of the
interface modules. Hopefully, someone else more knowledgeable in this
area will chime in...

Jason

--
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6