This is the mail archive of the
mailing list for the Cygwin project.
Re: postgresql-8.01 and 8.1 ready
On Fri, Sep 23, 2005 at 11:37:46AM +0200, Corinna Vinschen wrote:
> On Sep 23 10:30, Gerrit P. Haase wrote:
> > Reini Urban wrote:
> > >Gerrit P. Haase schrieb:
> > >>Reini Urban wrote:
> > >>>Installing as service is quite hard without sysbash,
> > >>>[snip]
> > So it is not possible to run this as service?
> > What is the problem with the method used in postgres 7?
> > [snip]
> Good questions. Ideally I'd assume that the new postgresql just works
> as a replacement for the old postgresql so that existing service
> installations using cygrunsrv are not suddenly broken.
To be specific, why doesn't the following (excerpt) from my PostgreSQL
7.x README work for 8.x?
$ net user postgres $password /add /fullname:postgres /comment:'PostgreSQL user account' /homedir:"$(cygpath -w /home/postgres)"
$ mkpasswd -l -u postgres >>/etc/passwd
$ cmd /c secpol.msc # grant postgres "Log on as a service" user right
$ cygrunsrv --install postmaster --path /usr/bin/postmaster --args "-D /var/postgresql/data -i" --dep cygserver --termsig INT --user postgres --shutdown
PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6