Re: starting postmaster W2K service - Mailing list pgsql-cygwin

From Akhona Damane
Subject Re: starting postmaster W2K service
Date
Msg-id sf9519f6.009@cs-imo.csir.co.za
Whole thread Raw
In response to starting postmaster W2K service  ("Michel (Free)" <mcharp@free.fr>)
List pgsql-cygwin
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.


pgsql-cygwin by date:

Previous
From: anilkumar@kiet.edu
Date:
Subject: Problem: unable to uninstall CYGWIN-IPC DAEMON after uninstalling PostgreSQL
Next
From: Jason Tishler
Date:
Subject: Re: Problem: unable to uninstall CYGWIN-IPC DAEMON after uninstalling PostgreSQL