Mailing-List: contact cygwin-help AT cygwin DOT com; run by ezmlm
List-Subscribe: <mailto:cygwin-subscribe AT cygwin DOT com>
List-Archive: <http://sourceware.org/ml/cygwin/>
List-Post: <mailto:cygwin AT cygwin DOT com>
List-Help: <mailto:cygwin-help AT cygwin DOT com>, <http://sourceware.org/ml/#faqs>
Sender: cygwin-owner AT cygwin DOT com
Mail-Followup-To: cygwin AT cygwin DOT com
Delivered-To: mailing list cygwin AT cygwin DOT com
Message-ID: <001b01c58817$430e8ea0$0200000a@agamemnon>
From: "Jon A. Lambert" <jlsysinc AT alltel DOT net>
To: "Jon A. Lambert" <jlsysinc AT alltel DOT net>, <cygwin AT cygwin DOT com>
References: <038e01c58612$834a8700$0200000a AT agamemnon> <42D26875 DOT 8080909 AT byu DOT net>  <01d801c586f2$c2573570$0200000a AT agamemnon> <03c001c587d0$4661a980$0200000a AT agamemnon> <Pine DOT GSO DOT 4 DOT 61 DOT 0507132054510 DOT 4871 AT slinky DOT cs DOT nyu DOT edu> <001201c58815$6abd0370$0200000a AT agamemnon>
Subject: Re: Postgres not working anymore
Date: Wed, 13 Jul 2005 21:56:33 -0400
MIME-Version: 1.0
Content-Type: text/plain; 	format=flowed; 	charset="iso-8859-1"; 	reply-type=response
Content-Transfer-Encoding: 7bit
X-IsSubscribed: yes

Jon A. Lambert wrote:

Some additional info:

I tried to start it the other way...

jlambert AT agamemnon /var/postgresql
$ /usr/bin/pg_ctl -D /var/postgresql/data -l logfile start
pg_ctl: Another postmaster may be running.  Trying to start postmaster 
anyway.
postmaster successfully started

jlambert AT agamemnon /var/postgresql
$ ps -e
      PID    PPID    PGID     WINPID  TTY  UID    STIME COMMAND
     3972       1    3972       3972  con 1004 21:20:59 /usr/bin/bash
     1420       1    1420       1420    ?   18 21:29:26 /usr/bin/cygrunsrv
     3332    1420    3332        200    ?   18 21:29:26 /usr/sbin/cygserver
     1600    3972    1600       3724  con 1004 21:50:45 /usr/bin/ps

It's not there.  Nor could I find the process in task manager.

jlambert AT agamemnon /var/postgresql
$ cat /var/log/postmaster.log

Empty log

jlambert AT agamemnon /var/postgresql
$ psql
psql: could not connect to server: Connection refused
        Is the server running locally and accepting
        connections on Unix domain socket "/tmp/.s.PGSQL.5432"?

Cannot connect either of course.

And my userid is Administrator on this machine.

jlambert AT agamemnon /var/postgresql
$ editrights -u jlambert -l
SeServiceLogonRight
SeBatchLogonRight

Hmmm.




--
Unsubscribe info:      http://cygwin.com/ml/#unsubscribe-simple
Problem reports:       http://cygwin.com/problems.html
Documentation:         http://cygwin.com/docs.html
FAQ:                   http://cygwin.com/faq/