Postgres not working anymore

Jon A. Lambert jlsysinc@alltel.net
Thu Jul 14 01:56:00 GMT 2005


Jon A. Lambert wrote:

Some additional info:

I tried to start it the other way...

jlambert@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@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@agamemnon /var/postgresql
$ cat /var/log/postmaster.log

Empty log

jlambert@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@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/



More information about the Cygwin mailing list