This is the mail archive of the cygwin mailing list for the Cygwin project.


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]
Other format: [Raw text]

Re: Postgres not working anymore


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/


Index Nav: [Date Index] [Subject Index] [Author Index] [Thread Index]
Message Nav: [Date Prev] [Date Next] [Thread Prev] [Thread Next]