Re: starting postmaster W2K service

Thank you, I also could not start PostgreSQL server, but after removiing postmaster.pid from the data directory - it worked.

Thank you again

Mr. Akhona Damane
CSIR Environmentek
Spatial Technology
(012) 841 3188
Fax (012) 8412689
adamane(at)csir(dot)co(dot)za

>>> "Michel (Free)" <mcharp(at)free(dot)fr> 10/20/03 02:26PM >>>
Hi Jason,
That helped definitly.

In the window event log, I find :
Beginning is in french but important message (at the end) is in english.

Impossible de trouver la description de l'ID d'événement ( 0 ) dans la
source ( postmaster ). L'ordinateur local n'a peut-être pas les informations
de Registre nécessaires ou les fichiers DLL de messagerie pour afficher
les messages provenant d'un ordinateur distant postmaster : PID 1472 :
starting service `' failed: redirect_fd: open (1, /var/log/postmaster.log):
13, Permission denied.

I found that I had an existing postmaster.log that belong to someone else so
I could'nt overwrite it .
I deleted it and now service starts

Probable my first service problem was about LOCALE (which I changed from
'french' to 'C' before using initDB)
Then I made some test to find out why my service startup was wrong, by
changing user for Windows service (from postgres to mch user)
Then I still got an error about service, but I think cause had changed. It
was not a LOCALE error anymore but a write permission about postmaster.log

Thanks for your quick response..
As it is my first time using mailing list, should I answer all (including
your personal email + mailing group) like this mail or should I only write
to mailing group ?

Michel

----- Original Message -----
From: "Jason Tishler" <jason(at)tishler(dot)net>
To: "Michel (Free)" <mcharp(at)free(dot)fr>
Cc: <pgsql-cygwin(at)postgresql(dot)org>
Sent: Monday, October 20, 2003 1:57 PM
Subject: Re: [CYGWIN] starting postmaster W2K service

> Michel,
>
> On Sat, Oct 18, 2003 at 01:02:32AM +0200, Michel (Free) wrote:
> > I got following error (on W2K)
> >
> > $ cygrunsrv -S postmaster
> > cygrunsrv: Error starting a service: QueryServiceStatus: Win32 error
1062:
> > Le service n'a pas été démarré.
> >
> > I cannot find any detailed error message.
> > Thanks for help
>
> Does the following help?
>
> http://archives.postgresql.org/pgsql-cygwin/2003-03/msg00021.php
>
> Jason
>
> --
> PGP/GPG Key: http://www.tishler.net/jason/pubkey.asc or key servers
> Fingerprint: 7A73 1405 7F2B E669 C19D 8784 1AFD E4CC ECF4 8EF6
>

---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ?

http://www.postgresql.org/docs/faqs/FAQ.html

--
This message has been scanned for viruses and
dangerous content by MailScanner, and is
believed to be clean.
Mailscanner thanks transtec Computers for their support.