Re: postgresql on windows 2000 - Mailing list pgsql-cygwin

i checked the event viewer log also
it gives following message
"The description for Event ID ( 0 ) in Source ( postmaster ) cannot be found. The local computer may not have the
necessaryregistry information or message DLL files to display messages from a remote computer. The following
informationis part of the event: postmaster : PID 1924 : `postmaster' service stopped." 

but i cannot make out anything from it.
>
>
><P><FONT SIZE=2>Check your Event Viewer-> Application log.  There might be more information about the error
there.</FONT>
></P>
>
><P><FONT SIZE=2>Mike</FONT>
></P>
>
><P><FONT SIZE=2>-----Original Message-----</FONT>
><BR><FONT SIZE=2>From: raj_14_11@rec-all.com [<A
HREF="mailto:raj_14_11@rec-all.com">mailto:raj_14_11@rec-all.com</A>]</FONT>
><BR><FONT SIZE=2>Sent: Monday, September 08, 2003 11:45 PM</FONT>
><BR><FONT SIZE=2>To: jason@tishler.net</FONT>
><BR><FONT SIZE=2>Cc: pgsql-cygwin@postgresql.org; godsham@speakeasy.net</FONT>
><BR><FONT SIZE=2>Subject: Re: [CYGWIN] postgresql on windows 2000</FONT>
></P>
><BR>
>
><P><FONT SIZE=2>Hi</FONT>
><BR><FONT SIZE=2>i have tried all possibilities and followed all the instructions but when it comes to start
postmasteri get this </FONT> 
><BR><FONT SIZE=2>********************************************</FONT>
><BR><FONT SIZE=2>$ net start postmaster</FONT>
><BR><FONT SIZE=2>The postmaster service is starting.</FONT>
><BR><FONT SIZE=2>The postmaster service could not be started.</FONT>
></P>
>
><P><FONT SIZE=2>The service did not report an error.</FONT>
></P>
>
><P><FONT SIZE=2>More help is available by typing NET HELPMSG 3534.</FONT>
></P>
>
><P><FONT SIZE=2>$ NET HELPMSG 3534</FONT>
></P>
>
><P><FONT SIZE=2>The service did not report an error.</FONT>
></P>
><BR>
>
><P><FONT SIZE=2>EXPLANATION</FONT>
></P>
>
><P><FONT SIZE=2>The service did not report an error.</FONT>
></P>
>
><P><FONT SIZE=2>ACTION</FONT>
></P>
>
><P><FONT SIZE=2>Try the task later. If the problem persists, contact your network</FONT>
><BR><FONT SIZE=2>administrator.</FONT>
><BR><FONT SIZE=2>********************************************</FONT>
><BR><FONT SIZE=2>can anybody help me ?</FONT>
></P>
>
><P><FONT SIZE=2>>Mike,</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>Please keep your replies on-list.</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>On Fri, Sep 05, 2003 at 09:10:05PM -0500, Mike G wrote:</FONT>
><BR><FONT SIZE=2>>> It sounds like the cygipc-daemon is running the wrong version.  The</FONT>
><BR><FONT SIZE=2>>> instructions located in the</FONT>
><BR><FONT SIZE=2>>> readme(<A HREF="http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README"
TARGET="_blank">http://www.tishler.net/jason/software/postgresql/postgresql-7.3.3.README</A>)</FONT>
><BR><FONT SIZE=2>>> need to be updated.</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>Have you seen the following?</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>    <A
HREF="http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README"
TARGET="_blank">http://www.tishler.net/jason/software/postgresql/postgresql-7.3.4.README</A></FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>> This is what it should read now:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> The following is the NT services Cygwin PostgreSQL installation</FONT>
><BR><FONT SIZE=2>>> procedure</FONT>
><BR><FONT SIZE=2>>> (with footnotes designated by "[n]"):</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 1. Install the cygipc ipc-daemon as a NT service:</FONT>
><BR><FONT SIZE=2>>>     A)If you are upgrading from a version prior to 7.3.4-2</FONT>
><BR><FONT SIZE=2>>>     shutdown the postmaster and cygipc services.</FONT>
><BR><FONT SIZE=2>>>     close the service manager screen.</FONT>
><BR><FONT SIZE=2>>>     # ipc-daemon --remove-as-service</FONT>
><BR><FONT SIZE=2>>>     # ipc-daemon2 --install-as-service</FONT>
><BR><FONT SIZE=2>>>     </FONT>
><BR><FONT SIZE=2>>>     Next skip to step 4.</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     B)If it is a fresh install</FONT>
><BR><FONT SIZE=2>>>     # ipc-daemon2 --install-as-service</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 2. Create the "postgres" user account:</FONT>
><BR><FONT SIZE=2>>>    </FONT>
><BR><FONT SIZE=2>>>     # net user postgres $password /add /fullname:postgres</FONT>
><BR><FONT SIZE=2>>> /comment:'PostgreSQL user account' /homedir:"$(cygpath -w</FONT>
><BR><FONT SIZE=2>>> /home/postgres)" # [11]</FONT>
><BR><FONT SIZE=2>>>     # mkpasswd -l -u postgres >>/etc/passwd</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 3. Grant the "postgres" user the "Log on as a service" user
right:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     # cmd /c secpol.msc # [3] [4] [5] [12]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 4. Install postmaster as a NT service:</FONT>
><BR><FONT SIZE=2>>>     A)If you are upgrading from a version prior to 7.3.4-2</FONT>
><BR><FONT SIZE=2>>>     # cygrunsrv --remove postmaster</FONT>
><BR><FONT SIZE=2>>>     # cygrunsrv --install postmaster --path /usr/bin/postmaster
--args</FONT>
><BR><FONT SIZE=2>>> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user</FONT>
><BR><FONT SIZE=2>>> postgres --shutdown # [6]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     Skip to step 7.</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     B)If you are doing a fresh install:</FONT>
><BR><FONT SIZE=2>>>     # cygrunsrv --install postmaster --path /usr/bin/postmaster
--args</FONT>
><BR><FONT SIZE=2>>> "-D /usr/share/postgresql/data -i" --dep ipc-daemon --termsig INT --user</FONT>
><BR><FONT SIZE=2>>> postgres --shutdown # [6]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 5. Create the PostgreSQL data directory:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     # mkdir /usr/share/postgresql/data</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 6. Change ownership of the PostgreSQL data directory:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     # chown postgres /usr/share/postgresql/data # [10]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 7. Start the cygipc ipc-daemon:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     # net start ipc-daemon2 # [7]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>    **If upgrading skip to step 9.</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 8. Initialize PostgreSQL (*when running under the "postgres" account*):</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     $ initdb -D /usr/share/postgresql/data</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 9. Start postmaster:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     # net start postmaster # [7]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> 10. Connect to PostgreSQL:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>>     # psql -U postgres template1 # [8] [9]</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> The following are the notes to the above:</FONT>
><BR><FONT SIZE=2>>> </FONT>
><BR><FONT SIZE=2>>> [snip]</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>Sorry, but I feel that my README is already too cluttered.  However, I</FONT>
><BR><FONT SIZE=2>>will add an issue regarding upgrading from 7.3.4-1 or earlier.</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>Thanks,</FONT>
><BR><FONT SIZE=2>>Jason</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>-- </FONT>
><BR><FONT SIZE=2>>PGP/GPG Key: <A HREF="http://www.tishler.net/jason/pubkey.asc"
TARGET="_blank">http://www.tishler.net/jason/pubkey.asc</A>or key servers</FONT> 
><BR><FONT SIZE=2>>Fingerprint: 7A73 1405 7F2B E669 C19D  8784 1AFD E4CC ECF4 8EF6</FONT>
><BR><FONT SIZE=2>></FONT>
><BR><FONT SIZE=2>>---------------------------(end of broadcast)---------------------------</FONT>
><BR><FONT SIZE=2>>TIP 2: you can get off all lists at once with the unregister command</FONT>
><BR><FONT SIZE=2>>    (send "unregister YourEmailAddressHere" to
majordomo@postgresql.org)</FONT>
></P>
>
><P><FONT SIZE=2>---------------------------------------------</FONT>
><BR><FONT SIZE=2>WWW.rec-all.com - a community of all the RECs</FONT>
></P>
>
><P><FONT SIZE=2>---------------------------(end of broadcast)---------------------------</FONT>
><BR><FONT SIZE=2>TIP 8: explain analyze is your friend</FONT>
></P>
>

---------------------------------------------
WWW.rec-all.com - a community of all the RECs