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@csir.co.za
>>> "Michel (Free)" <mcharp@free.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@tishler.net>
To: "Michel (Free)" <mcharp@free.fr>
Cc: <pgsql-cygwin@postgresql.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.
