Skip site navigation (1) Skip section navigation (2)

postgresql startup problem on win2k

From: "dave" <dmehler(at)davemehler(dot)com>
To: <pgsql-cygwin(at)postgresql(dot)org>
Cc: <dmehler(at)davemehler(dot)com>
Subject: postgresql startup problem on win2k
Date: 2001-12-31 20:12:15
Message-ID: 000901c19237$71219f50$0200a8c0@satellite (view raw or flat)
Thread:
Lists: pgsql-cygwin
Hello,
    I wrote about this a while back, but didn't get anywhere in fixing it. So because of another reason i had to reinstall 2k on my laptop, and i did a cygwin upgrade, setup version 2.125.2.10, cygwin .dll version 1.3.6, which came with postgresql, and i'm having the same problem. Here goes.
    Installed 2k and service pack 2, downloaded cygwin, installed it, then i went and got the latest ipc-daemon 1.11 i bellieve the version is, installed and started it, it worked fine. I then created the postgres user account in control panel/users and passwords, and granted said user the log on as a service right in security policies. I then installed postmaster as a service. 
 cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user postgres --shutdown
I then created the postgresql data directory and chowned it to postgres, finally i sshd to localhost and logged in as postgres and initialized the database:
initdb -D /usr/share/postgresql/data
and started postmaster:
net start postmaster
I was then able to connect to postgresql using psql.
    Ok, did all that, then some more unrelated stuff, then shutdown. This morning i find the postmaster service wasn't started even though it had it's startup status set to automatic. I then tried to start it from service manager and from net start, each time getting the service did not return an error code, net helpmsg 3534 which basically said the same thing. I then got the bright idea of checking my logs, they're attached. the log.txt is my application log, where i see some information about postmaster complaining about missing registry keys, and the syslog.txt is the system log where i'm getting some errors from what looks like the server service, that i do not know if they're related.
    I would appreciate any suggestions, and i apologize for the long winded nature of this email.
Thanks.
Dave.


Attachment: syslog.txt
Description: text/plain (765 bytes)
Attachment: log.txt
Description: text/plain (3.7 KB)

Responses

pgsql-cygwin by date

Next:From: fredDate: 2001-12-31 21:39:05
Subject: Re: postgresql startup problem on win2k
Previous:From: Gerrit P. HaaseDate: 2001-12-31 19:36:29
Subject: Re: Cygwin DBD::Pg

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group