Re: a few questions - Mailing list pgsql-cygwin

From Jason Tishler
Subject Re: a few questions
Date
Msg-id 20030801133852.GA2240@tishler.net
Whole thread Raw
In response to a few questions  (William Grigg <wgrigg@draper.com>)
List pgsql-cygwin
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

pgsql-cygwin by date:

Previous
From: Xinyu Hua
Date:
Subject: load database from ascii files
Next
From: Jason Tishler
Date:
Subject: Re: Postgres : error while running initdb