Raymond,
Josh's is suggestion is correct. Please post to
pgsql-cygwin@postgresql.org
instead of sending private email. In addition to helping others, you
may find that you get a (much) faster response.
BTW, to reply to a posting you just need to use the "reply all" feature
of you mailer (assuming that you have already subscribed to the mailing
list).
Jason
On Tue, Jan 29, 2002 at 08:00:25AM -0800, Josh Berkus wrote:
> There is a pgsql-cygwin mailing list. I highly suggest that you post
> your question there.
>
> BTW, it sounds like for some reason pg_ctl cannot delete the PID file
> in pgsql/data -- probably a permissions issue.
>
> On Tue, Jan 29, 2002 at 07:34:25PM +0800, Raymond Wee wrote:
> > I had encountered the same problems as Oliver
> > (http://archives.postgresql.org/pgsql-novice/2001-12/msg00034.php)
> > w/
> > regards to pg_ctl stop without changing pg_hba.conf or pg_ident.conf.
> > Here
> > is the sequence of steps that I did:
> >
> > load cygwin shell
> >
> > $ pg_ctl start -o "-i"
> > $ ps
> > --> the /usr/bin/postgres process id shows up
> > $ pg_ctl stop -m smart
> > --> the screen prompts that the server is waiting to shutdown
> > .......................................... then it mentioned that
> > shutdown
> > failed
> > $ pg_ctl status
> > --> it was able to display a process id indicating that the
> > postmaster is
> > still running
> > $ ps
> > --> only /usr/bin/bash and /usr/bin/ps are displayed....
> >
> > I don't get it, pg_ctl seems to record some process id showing that
> > postmaster is running but ps does not....
> >
> > not only that, after shutdown, the postmaster.pid still exists on the
> > /usr/local/pgsql/data directory, and some lock file still exist on
> > /tmp
> > directory.
> >
> > I compared the cygwin directory of my pc with another computer using
> > windiff, curiously one of the differences is that the file
> > /etc/pg_hba.conf
> > exists while mine exists on another directory? is this the cause of
> > the
> > problem? or is this an irrelevant issue?
> >
> > btw, I'm using the administrator account since i'm using cygwin and
> > my os is
> > win2k professional.
> >
> > Thanks in advance!
> >
> > Raymond
> >
> > P.S. I would have replied to the thread unfortunately, I can't see
> > any
> > button "reply to this thread" or something to that effect. Sorry...